Overview

Brought to you by YData

Dataset statistics

Number of variables	54
Number of observations	84949
Missing cells	142785
Missing cells (%)	3.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	139.2 MiB
Average record size in memory	1.7 KiB

Variable types

Numeric	21
Text	13
Categorical	19
DateTime	1

Alerts

`booking_adult_count` is highly overall correlated with `booking_pax_count`	High correlation
`booking_leg_count` is highly overall correlated with `booking_trip_type`	High correlation
`booking_original_currency` is highly overall correlated with `preffered_language`	High correlation
`booking_pax_count` is highly overall correlated with `booking_adult_count`	High correlation
`booking_reservation_month` is highly overall correlated with `leg_departure_month`	High correlation
`booking_segments_count` is highly overall correlated with `booking_trip_type`	High correlation
`booking_trip_type` is highly overall correlated with `booking_leg_count` and 1 other fields	High correlation
`coupon_cabin_class` is highly overall correlated with `coupon_rbd_code`	High correlation
`coupon_miles` is highly overall correlated with `coupon_range` and 1 other fields	High correlation
`coupon_number` is highly overall correlated with `leg_number`	High correlation
`coupon_range` is highly overall correlated with `coupon_miles`	High correlation
`coupon_rbd_code` is highly overall correlated with `coupon_cabin_class`	High correlation
`graphic_design` is highly overall correlated with `top_1_section` and 2 other fields	High correlation
`leg_departure_month` is highly overall correlated with `booking_reservation_month`	High correlation
`leg_destination_country_code` is highly overall correlated with `coupon_miles` and 1 other fields	High correlation
`leg_first_leg_flg` is highly overall correlated with `leg_last_leg_flg` and 1 other fields	High correlation
`leg_hours_to_departure` is highly overall correlated with `leg_origin_country_code`	High correlation
`leg_last_leg_flg` is highly overall correlated with `leg_first_leg_flg` and 1 other fields	High correlation
`leg_number` is highly overall correlated with `coupon_number`	High correlation
`leg_origin_country_code` is highly overall correlated with `leg_hours_to_departure` and 1 other fields	High correlation
`leg_stopover_time_h` is highly overall correlated with `leg_first_leg_flg` and 1 other fields	High correlation
`preffered_language` is highly overall correlated with `booking_original_currency` and 2 other fields	High correlation
`top_1_section` is highly overall correlated with `graphic_design` and 2 other fields	High correlation
`top_2_section` is highly overall correlated with `graphic_design` and 1 other fields	High correlation
`top_3_section` is highly overall correlated with `graphic_design` and 1 other fields	High correlation
`booking_infant_count` is highly imbalanced (95.1%)	Imbalance
`booking_leg_count` is highly imbalanced (56.5%)	Imbalance
`booking_payment_method` is highly imbalanced (73.4%)	Imbalance
`booking_sales_channel` is highly imbalanced (54.8%)	Imbalance
`coupon_cabin_class` is highly imbalanced (88.6%)	Imbalance
`coupon_range` is highly imbalanced (62.3%)	Imbalance
`booking_destination_airport_code` has 5199 (6.1%) missing values	Missing
`booking_original_currency` has 7318 (8.6%) missing values	Missing
`leg_destination_country_code` has 65106 (76.6%) missing values	Missing
`leg_origin_country_code` has 65079 (76.6%) missing values	Missing
`id` has unique values	Unique
`booking_child_count` has 81146 (95.5%) zeros	Zeros
`booking_window_w` has 7291 (8.6%) zeros	Zeros
`leg_duration_h` has 3115 (3.7%) zeros	Zeros
`top_3_section` has 16945 (19.9%) zeros	Zeros

Reproduction

Analysis started	2025-04-12 09:49:12.297520
Analysis finished	2025-04-12 09:50:45.717507
Duration	1 minute and 33.42 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

id
Real number (ℝ)

Unique

Distinct	84949
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57911.408

Minimum	0
Maximum	116328
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	0
5-th percentile	5683.2
Q1	28606
median	57711
Q3	87172
95-th percentile	110589.2
Maximum	116328
Range	116328
Interquartile range (IQR)	58566

Descriptive statistics

Standard deviation	33694.182
Coefficient of variation (CV)	0.58182288
Kurtosis	-1.204811
Mean	57911.408
Median Absolute Deviation (MAD)	29280
Skewness	0.014588137
Sum	4.9195162 × 10⁹
Variance	1.1352979 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
105529	1	< 0.1%
85092	1	< 0.1%
58605	1	< 0.1%
26759	1	< 0.1%
15674	1	< 0.1%
64692	1	< 0.1%
78039	1	< 0.1%
115584	1	< 0.1%
22480	1	< 0.1%
109814	1	< 0.1%
Other values (84939)	84939	> 99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
13	1	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
116328	1	< 0.1%
116327	1	< 0.1%
116326	1	< 0.1%
116325	1	< 0.1%
116324	1	< 0.1%
116320	1	< 0.1%
116319	1	< 0.1%
116317	1	< 0.1%
116314	1	< 0.1%
116313	1	< 0.1%

booking_adult_count
Real number (ℝ)

High correlation

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4624775

Minimum	0
Maximum	96
Zeros	34
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	96
Range	96
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.4794811
Coefficient of variation (CV)	1.0116266
Kurtosis	636.44277
Mean	1.4624775
Median Absolute Deviation (MAD)	0
Skewness	18.30858
Sum	124236
Variance	2.1888643
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
1	59936	70.6%
2	19367	22.8%
3	3038	3.6%
4	1444	1.7%
5	391	0.5%
6	209	0.2%
7	117	0.1%
8	104	0.1%
9	57	0.1%
0	34	< 0.1%
Other values (39)	252	0.3%

Value	Count	Frequency (%)
0	34	< 0.1%
1	59936	70.6%
2	19367	22.8%
3	3038	3.6%
4	1444	1.7%
5	391	0.5%
6	209	0.2%
7	117	0.1%
8	104	0.1%
9	57	0.1%

Value	Count	Frequency (%)
96	1	< 0.1%
92	1	< 0.1%
55	1	< 0.1%
53	1	< 0.1%
50	1	< 0.1%
49	1	< 0.1%
47	1	< 0.1%
45	3	< 0.1%
44	2	< 0.1%
43	2	< 0.1%

booking_child_count
Real number (ℝ)

Zeros

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.057975962

Minimum	0
Maximum	5
Zeros	81146
Zeros (%)	95.5%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.29031121
Coefficient of variation (CV)	5.007441
Kurtosis	39.393484
Mean	0.057975962
Median Absolute Deviation (MAD)	0
Skewness	5.8444326
Sum	4925
Variance	0.0842806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	81146	95.5%
1	2805	3.3%
2	886	1.0%
3	102	0.1%
4	8	< 0.1%
5	2	< 0.1%

Value	Count	Frequency (%)
0	81146	95.5%
1	2805	3.3%
2	886	1.0%
3	102	0.1%
4	8	< 0.1%
5	2	< 0.1%

Value	Count	Frequency (%)
5	2	< 0.1%
4	8	< 0.1%
3	102	0.1%
2	886	1.0%
1	2805	3.3%
0	81146	95.5%

booking_destination_airport_code
Text

Missing

Distinct	88
Distinct (%)	0.1%
Missing	5199
Missing (%)	6.1%
Memory size	4.1 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	239250
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	TBS
2nd row	WAW
3rd row	BEG
4th row	BOM
5th row	OTP

Value	Count	Frequency (%)
waw	21676	27.2%
lhr	2424	3.0%
ams	1941	2.4%
vno	1857	2.3%
jfk	1771	2.2%
ist	1726	2.2%
krk	1726	2.2%
ord	1710	2.1%
cdg	1541	1.9%
prg	1489	1.9%
Other values (78)	41889	52.5%

Most occurring characters

Value	Count	Frequency (%)
W	44798	18.7%
A	32729	13.7%
R	17183	7.2%
O	10174	4.3%
L	10011	4.2%
T	9441	3.9%
D	9298	3.9%
C	8940	3.7%
S	8728	3.6%
N	7938	3.3%
Other values (16)	80010	33.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	239250	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	44798	18.7%
A	32729	13.7%
R	17183	7.2%
O	10174	4.3%
L	10011	4.2%
T	9441	3.9%
D	9298	3.9%
C	8940	3.7%
S	8728	3.6%
N	7938	3.3%
Other values (16)	80010	33.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	239250	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	44798	18.7%
A	32729	13.7%
R	17183	7.2%
O	10174	4.3%
L	10011	4.2%
T	9441	3.9%
D	9298	3.9%
C	8940	3.7%
S	8728	3.6%
N	7938	3.3%
Other values (16)	80010	33.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	239250	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	44798	18.7%
A	32729	13.7%
R	17183	7.2%
O	10174	4.3%
L	10011	4.2%
T	9441	3.9%
D	9298	3.9%
C	8940	3.7%
S	8728	3.6%
N	7938	3.3%
Other values (16)	80010	33.4%

booking_id
Real number (ℝ)

Distinct	81734
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5503856

Minimum	1000143
Maximum	9999956
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1000143
5-th percentile	1459341.4
Q1	3251179
median	5503001
Q3	7740747
95-th percentile	9557143.2
Maximum	9999956
Range	8999813
Interquartile range (IQR)	4489568

Descriptive statistics

Standard deviation	2593980.4
Coefficient of variation (CV)	0.47130237
Kurtosis	-1.1946804
Mean	5503856
Median Absolute Deviation (MAD)	2244662
Skewness	-0.00042049661
Sum	4.6754706 × 10¹¹
Variance	6.7287343 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5567317	11	< 0.1%
7494700	7	< 0.1%
5709675	6	< 0.1%
2434140	5	< 0.1%
2198660	5	< 0.1%
4075744	5	< 0.1%
2057360	5	< 0.1%
1817985	5	< 0.1%
5837515	4	< 0.1%
5534177	4	< 0.1%
Other values (81724)	84892	99.9%

Value	Count	Frequency (%)
1000143	1	< 0.1%
1000588	1	< 0.1%
1000605	2	< 0.1%
1000843	1	< 0.1%
1000848	1	< 0.1%
1000860	2	< 0.1%
1000899	1	< 0.1%
1001098	1	< 0.1%
1001137	1	< 0.1%
1001169	1	< 0.1%

Value	Count	Frequency (%)
9999956	1	< 0.1%
9999704	1	< 0.1%
9999596	1	< 0.1%
9999457	1	< 0.1%
9999335	1	< 0.1%
9999264	1	< 0.1%
9999220	1	< 0.1%
9999172	1	< 0.1%
9999053	1	< 0.1%
9999041	1	< 0.1%

booking_infant_count
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

0	83907
1	1022
2	19
4	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	83907	98.8%
1	1022	1.2%
2	19	< 0.1%
4	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	83907	98.8%
1	1022	1.2%
2	19	< 0.1%
4	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	83907	98.8%
1	1022	1.2%
2	19	< 0.1%
4	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	83907	98.8%
1	1022	1.2%
2	19	< 0.1%
4	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	83907	98.8%
1	1022	1.2%
2	19	< 0.1%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	83907	98.8%
1	1022	1.2%
2	19	< 0.1%
4	1	< 0.1%

booking_leg_count
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

2	61847
1	22840
3	252
4	10

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
2	61847	72.8%
1	22840	26.9%
3	252	0.3%
4	10	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	61847	72.8%
1	22840	26.9%
3	252	0.3%
4	10	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
2	61847	72.8%
1	22840	26.9%
3	252	0.3%
4	10	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	61847	72.8%
1	22840	26.9%
3	252	0.3%
4	10	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	61847	72.8%
1	22840	26.9%
3	252	0.3%
4	10	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	61847	72.8%
1	22840	26.9%
3	252	0.3%
4	10	< 0.1%

booking_market
Text

Distinct	72
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	169898
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	GE
2nd row	US
3rd row	PL
4th row	SE
5th row	PL

Value	Count	Frequency (%)
pl	30864	36.3%
us	10015	11.8%
se	9310	11.0%
gb	3410	4.0%
de	3067	3.6%
ca	2491	2.9%
lt	2349	2.8%
nl	1700	2.0%
ee	1625	1.9%
dk	1605	1.9%
Other values (62)	18513	21.8%

Most occurring characters

Value	Count	Frequency (%)
L	36334	21.4%
P	31131	18.3%
S	21680	12.8%
E	18932	11.1%
U	11701	6.9%
B	5125	3.0%
D	4999	2.9%
C	4902	2.9%
R	4675	2.8%
G	4440	2.6%
Other values (15)	25979	15.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	169898	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	36334	21.4%
P	31131	18.3%
S	21680	12.8%
E	18932	11.1%
U	11701	6.9%
B	5125	3.0%
D	4999	2.9%
C	4902	2.9%
R	4675	2.8%
G	4440	2.6%
Other values (15)	25979	15.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	169898	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	36334	21.4%
P	31131	18.3%
S	21680	12.8%
E	18932	11.1%
U	11701	6.9%
B	5125	3.0%
D	4999	2.9%
C	4902	2.9%
R	4675	2.8%
G	4440	2.6%
Other values (15)	25979	15.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	169898	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	36334	21.4%
P	31131	18.3%
S	21680	12.8%
E	18932	11.1%
U	11701	6.9%
B	5125	3.0%
D	4999	2.9%
C	4902	2.9%
R	4675	2.8%
G	4440	2.6%
Other values (15)	25979	15.3%

booking_origin_airport_code
Text

Distinct	86
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	254847
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WAW
2nd row	EWR
3rd row	SZZ
4th row	WAW
5th row	OSL

Value	Count	Frequency (%)
waw	32282	38.0%
vno	2980	3.5%
lhr	2669	3.1%
ord	2179	2.6%
jfk	1916	2.3%
krk	1852	2.2%
yyz	1852	2.2%
ams	1822	2.1%
tll	1744	2.1%
otp	1643	1.9%
Other values (76)	34010	40.0%

Most occurring characters

Value	Count	Frequency (%)
W	66876	26.2%
A	40456	15.9%
R	18368	7.2%
O	12353	4.8%
L	11155	4.4%
D	7611	3.0%
S	7424	2.9%
N	7184	2.8%
T	7137	2.8%
K	6454	2.5%
Other values (16)	69829	27.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	66876	26.2%
A	40456	15.9%
R	18368	7.2%
O	12353	4.8%
L	11155	4.4%
D	7611	3.0%
S	7424	2.9%
N	7184	2.8%
T	7137	2.8%
K	6454	2.5%
Other values (16)	69829	27.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	66876	26.2%
A	40456	15.9%
R	18368	7.2%
O	12353	4.8%
L	11155	4.4%
D	7611	3.0%
S	7424	2.9%
N	7184	2.8%
T	7137	2.8%
K	6454	2.5%
Other values (16)	69829	27.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	66876	26.2%
A	40456	15.9%
R	18368	7.2%
O	12353	4.8%
L	11155	4.4%
D	7611	3.0%
S	7424	2.9%
N	7184	2.8%
T	7137	2.8%
K	6454	2.5%
Other values (16)	69829	27.4%

booking_original_currency
Categorical

High correlation Missing

Distinct	42
Distinct (%)	0.1%
Missing	7318
Missing (%)	8.6%
Memory size	4.2 MiB

PLN	28679
EUR	16648
USD	9916
SEK	8352
GBP	3105
Other values (37)	10931

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	232893
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	GEL
2nd row	USD
3rd row	PLN
4th row	PLN
5th row	PLN

Common Values

Value	Count	Frequency (%)
PLN	28679	33.8%
EUR	16648	19.6%
USD	9916	11.7%
SEK	8352	9.8%
GBP	3105	3.7%
CAD	2297	2.7%
DKK	1477	1.7%
NOK	1150	1.4%
CHF	1069	1.3%
CZK	991	1.2%
Other values (32)	3947	4.6%
(Missing)	7318	8.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pln	28679	36.9%
eur	16648	21.4%
usd	9916	12.8%
sek	8352	10.8%
gbp	3105	4.0%
cad	2297	3.0%
dkk	1477	1.9%
nok	1150	1.5%
chf	1069	1.4%
czk	991	1.3%
Other values (32)	3947	5.1%

Most occurring characters

Value	Count	Frequency (%)
P	32072	13.8%
N	31084	13.3%
L	29029	12.5%
U	27189	11.7%
E	25503	11.0%
S	18647	8.0%
R	18535	8.0%
K	14117	6.1%
D	14027	6.0%
C	4380	1.9%
Other values (15)	18310	7.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	232893	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	32072	13.8%
N	31084	13.3%
L	29029	12.5%
U	27189	11.7%
E	25503	11.0%
S	18647	8.0%
R	18535	8.0%
K	14117	6.1%
D	14027	6.0%
C	4380	1.9%
Other values (15)	18310	7.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	232893	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	32072	13.8%
N	31084	13.3%
L	29029	12.5%
U	27189	11.7%
E	25503	11.0%
S	18647	8.0%
R	18535	8.0%
K	14117	6.1%
D	14027	6.0%
C	4380	1.9%
Other values (15)	18310	7.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	232893	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	32072	13.8%
N	31084	13.3%
L	29029	12.5%
U	27189	11.7%
E	25503	11.0%
S	18647	8.0%
R	18535	8.0%
K	14117	6.1%
D	14027	6.0%
C	4380	1.9%
Other values (15)	18310	7.9%

booking_pax_count
Real number (ℝ)

High correlation

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5329786

Minimum	1
Maximum	96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	96
Range	95
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.53779
Coefficient of variation (CV)	1.0031386
Kurtosis	555.78944
Mean	1.5329786
Median Absolute Deviation (MAD)	0
Skewness	16.521934
Sum	130225
Variance	2.364798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
1	58414	68.8%
2	18403	21.7%
3	4247	5.0%
4	2410	2.8%
5	611	0.7%
6	284	0.3%
7	142	0.2%
8	115	0.1%
9	69	0.1%
10	27	< 0.1%
Other values (39)	227	0.3%

Value	Count	Frequency (%)
1	58414	68.8%
2	18403	21.7%
3	4247	5.0%
4	2410	2.8%
5	611	0.7%
6	284	0.3%
7	142	0.2%
8	115	0.1%
9	69	0.1%
10	27	< 0.1%

Value	Count	Frequency (%)
96	1	< 0.1%
94	1	< 0.1%
55	1	< 0.1%
53	1	< 0.1%
50	1	< 0.1%
49	1	< 0.1%
47	1	< 0.1%
45	3	< 0.1%
44	2	< 0.1%
43	2	< 0.1%

booking_payment_method
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

95582540167d4ebb9497a7031f046757	76491
1bb2b25a099d4a438425d276203a0c2c	7087
e248b21630a9467cbdff5232836930a3	1364
236d48d3e6ce425599faccbf2f0a06f2	7

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	2718368
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	95582540167d4ebb9497a7031f046757
2nd row	95582540167d4ebb9497a7031f046757
3rd row	1bb2b25a099d4a438425d276203a0c2c
4th row	1bb2b25a099d4a438425d276203a0c2c
5th row	95582540167d4ebb9497a7031f046757

Common Values

Value	Count	Frequency (%)
95582540167d4ebb9497a7031f046757	76491	90.0%
1bb2b25a099d4a438425d276203a0c2c	7087	8.3%
e248b21630a9467cbdff5232836930a3	1364	1.6%
236d48d3e6ce425599faccbf2f0a06f2	7	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
95582540167d4ebb9497a7031f046757	76491	90.0%
1bb2b25a099d4a438425d276203a0c2c	7087	8.3%
e248b21630a9467cbdff5232836930a3	1364	1.6%
236d48d3e6ce425599faccbf2f0a06f2	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
7	390906	14.4%
4	329967	12.1%
5	321516	11.8%
0	253476	9.3%
9	246389	9.1%
b	176978	6.5%
6	164182	6.0%
1	161433	5.9%
2	124497	4.6%
a	100494	3.7%
Other values (6)	448530	16.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
7	390906	14.4%
4	329967	12.1%
5	321516	11.8%
0	253476	9.3%
9	246389	9.1%
b	176978	6.5%
6	164182	6.0%
1	161433	5.9%
2	124497	4.6%
a	100494	3.7%
Other values (6)	448530	16.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
7	390906	14.4%
4	329967	12.1%
5	321516	11.8%
0	253476	9.3%
9	246389	9.1%
b	176978	6.5%
6	164182	6.0%
1	161433	5.9%
2	124497	4.6%
a	100494	3.7%
Other values (6)	448530	16.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
7	390906	14.4%
4	329967	12.1%
5	321516	11.8%
0	253476	9.3%
9	246389	9.1%
b	176978	6.5%
6	164182	6.0%
1	161433	5.9%
2	124497	4.6%
a	100494	3.7%
Other values (6)	448530	16.5%

booking_reservation_month
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6554756

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	7
median	9
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.1448372
Coefficient of variation (CV)	0.41079579
Kurtosis	-0.13013452
Mean	7.6554756
Median Absolute Deviation (MAD)	1
Skewness	-0.94006014
Sum	650325
Variance	9.890001
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
9	17694	20.8%
8	14115	16.6%
10	13381	15.8%
1	7670	9.0%
7	7363	8.7%
11	7118	8.4%
12	4786	5.6%
2	4612	5.4%
6	3266	3.8%
5	2139	2.5%
Other values (2)	2805	3.3%

Value	Count	Frequency (%)
1	7670	9.0%
2	4612	5.4%
3	1327	1.6%
4	1478	1.7%
5	2139	2.5%
6	3266	3.8%
7	7363	8.7%
8	14115	16.6%
9	17694	20.8%
10	13381	15.8%

Value	Count	Frequency (%)
12	4786	5.6%
11	7118	8.4%
10	13381	15.8%
9	17694	20.8%
8	14115	16.6%
7	7363	8.7%
6	3266	3.8%
5	2139	2.5%
4	1478	1.7%
3	1327	1.6%

booking_sales_channel
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

website	57710
agents	25366
call_center	1088
aiport_agents	644
internal_agents	141

Length

Max length	15
Median length	7
Mean length	6.8113927
Min length	6

Characters and Unicode

Total characters	578621
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	website
2nd row	website
3rd row	website
4th row	agents
5th row	agents

Common Values

Value	Count	Frequency (%)
website	57710	67.9%
agents	25366	29.9%
call_center	1088	1.3%
aiport_agents	644	0.8%
internal_agents	141	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
website	57710	67.9%
agents	25366	29.9%
call_center	1088	1.3%
aiport_agents	644	0.8%
internal_agents	141	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	143888	24.9%
t	85734	14.8%
s	83861	14.5%
i	58495	10.1%
w	57710	10.0%
b	57710	10.0%
a	28024	4.8%
n	27521	4.8%
g	26151	4.5%
l	2317	0.4%
Other values (5)	7210	1.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	578621	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	143888	24.9%
t	85734	14.8%
s	83861	14.5%
i	58495	10.1%
w	57710	10.0%
b	57710	10.0%
a	28024	4.8%
n	27521	4.8%
g	26151	4.5%
l	2317	0.4%
Other values (5)	7210	1.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	578621	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	143888	24.9%
t	85734	14.8%
s	83861	14.5%
i	58495	10.1%
w	57710	10.0%
b	57710	10.0%
a	28024	4.8%
n	27521	4.8%
g	26151	4.5%
l	2317	0.4%
Other values (5)	7210	1.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	578621	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	143888	24.9%
t	85734	14.8%
s	83861	14.5%
i	58495	10.1%
w	57710	10.0%
b	57710	10.0%
a	28024	4.8%
n	27521	4.8%
g	26151	4.5%
l	2317	0.4%
Other values (5)	7210	1.2%

booking_segments_count
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2488905

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	6
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.95216071
Coefficient of variation (CV)	0.42339132
Kurtosis	-0.23977367
Mean	2.2488905
Median Absolute Deviation (MAD)	0
Skewness	0.84027966
Sum	191041
Variance	0.90661002
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	51996	61.2%
4	16268	19.2%
1	14101	16.6%
3	2526	3.0%
5	50	0.1%
6	8	< 0.1%

Value	Count	Frequency (%)
1	14101	16.6%
2	51996	61.2%
3	2526	3.0%
4	16268	19.2%
5	50	0.1%
6	8	< 0.1%

Value	Count	Frequency (%)
6	8	< 0.1%
5	50	0.1%
4	16268	19.2%
3	2526	3.0%
2	51996	61.2%
1	14101	16.6%

booking_trip_type
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

RT	58787
OW	20963
MC	5199

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	169898
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RT
2nd row	RT
3rd row	RT
4th row	OW
5th row	RT

Common Values

Value	Count	Frequency (%)
RT	58787	69.2%
OW	20963	24.7%
MC	5199	6.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rt	58787	69.2%
ow	20963	24.7%
mc	5199	6.1%

Most occurring characters

Value	Count	Frequency (%)
R	58787	34.6%
T	58787	34.6%
O	20963	12.3%
W	20963	12.3%
M	5199	3.1%
C	5199	3.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	169898	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	58787	34.6%
T	58787	34.6%
O	20963	12.3%
W	20963	12.3%
M	5199	3.1%
C	5199	3.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	169898	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	58787	34.6%
T	58787	34.6%
O	20963	12.3%
W	20963	12.3%
M	5199	3.1%
C	5199	3.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	169898	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	58787	34.6%
T	58787	34.6%
O	20963	12.3%
W	20963	12.3%
M	5199	3.1%
C	5199	3.1%

booking_window_w
Real number (ℝ)

Zeros

Distinct	53
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.915667

Minimum	0
Maximum	53
Zeros	7291
Zeros (%)	8.6%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	4
Q3	7
95-th percentile	20
Maximum	53
Range	53
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	6.9075653
Coefficient of variation (CV)	1.1676731
Kurtosis	8.1100139
Mean	5.915667
Median Absolute Deviation (MAD)	3
Skewness	2.5357693
Sum	502530
Variance	47.714459
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	12756	15.0%
2	11212	13.2%
3	9535	11.2%
4	7918	9.3%
0	7291	8.6%
5	6175	7.3%
6	5102	6.0%
7	4012	4.7%
8	3370	4.0%
9	2490	2.9%
Other values (43)	15088	17.8%

Value	Count	Frequency (%)
0	7291	8.6%
1	12756	15.0%
2	11212	13.2%
3	9535	11.2%
4	7918	9.3%
5	6175	7.3%
6	5102	6.0%
7	4012	4.7%
8	3370	4.0%
9	2490	2.9%

Value	Count	Frequency (%)
53	2	< 0.1%
51	5	< 0.1%
50	15	< 0.1%
49	42	< 0.1%
48	44	0.1%
47	31	< 0.1%
46	45	0.1%
45	22	< 0.1%
44	28	< 0.1%
43	34	< 0.1%

coupon_cabin_class
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

economy	83648
premium	1301

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	594643
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	economy
2nd row	economy
3rd row	economy
4th row	economy
5th row	economy

Common Values

Value	Count	Frequency (%)
economy	83648	98.5%
premium	1301	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
economy	83648	98.5%
premium	1301	1.5%

Most occurring characters

Value	Count	Frequency (%)
o	167296	28.1%
m	86250	14.5%
e	84949	14.3%
c	83648	14.1%
n	83648	14.1%
y	83648	14.1%
p	1301	0.2%
r	1301	0.2%
i	1301	0.2%
u	1301	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	594643	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	167296	28.1%
m	86250	14.5%
e	84949	14.3%
c	83648	14.1%
n	83648	14.1%
y	83648	14.1%
p	1301	0.2%
r	1301	0.2%
i	1301	0.2%
u	1301	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	594643	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	167296	28.1%
m	86250	14.5%
e	84949	14.3%
c	83648	14.1%
n	83648	14.1%
y	83648	14.1%
p	1301	0.2%
r	1301	0.2%
i	1301	0.2%
u	1301	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	594643	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	167296	28.1%
m	86250	14.5%
e	84949	14.3%
c	83648	14.1%
n	83648	14.1%
y	83648	14.1%
p	1301	0.2%
r	1301	0.2%
i	1301	0.2%
u	1301	0.2%

coupon_destination_airport_code
Text

Distinct	82
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	254847
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	WAW
2nd row	EWR
3rd row	WAW
4th row	BOM
5th row	WAW

Value	Count	Frequency (%)
waw	40154	47.3%
lhr	2429	2.9%
ord	1934	2.3%
jfk	1857	2.2%
ams	1806	2.1%
vno	1589	1.9%
yyz	1480	1.7%
bru	1220	1.4%
cdg	1168	1.4%
otp	1120	1.3%
Other values (72)	30192	35.5%

Most occurring characters

Value	Count	Frequency (%)
W	81332	31.9%
A	48754	19.1%
R	13997	5.5%
L	8562	3.4%
O	8102	3.2%
D	7134	2.8%
C	6734	2.6%
S	6724	2.6%
T	6259	2.5%
H	5687	2.2%
Other values (16)	61562	24.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	81332	31.9%
A	48754	19.1%
R	13997	5.5%
L	8562	3.4%
O	8102	3.2%
D	7134	2.8%
C	6734	2.6%
S	6724	2.6%
T	6259	2.5%
H	5687	2.2%
Other values (16)	61562	24.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	81332	31.9%
A	48754	19.1%
R	13997	5.5%
L	8562	3.4%
O	8102	3.2%
D	7134	2.8%
C	6734	2.6%
S	6724	2.6%
T	6259	2.5%
H	5687	2.2%
Other values (16)	61562	24.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	81332	31.9%
A	48754	19.1%
R	13997	5.5%
L	8562	3.4%
O	8102	3.2%
D	7134	2.8%
C	6734	2.6%
S	6724	2.6%
T	6259	2.5%
H	5687	2.2%
Other values (16)	61562	24.2%

coupon_fare_basis
Text

Distinct	4571
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	2718368
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1412 ?
Unique (%)	1.7%

Sample

1st row	ee702af56c9f42c49677ede02047afcd
2nd row	64e30cc1470248f6896a74d5774954b8
3rd row	76c8fafae85c47e0849a2b85b23dce08
4th row	9915e38b5cf247588f6f4ae680b53f5e
5th row	0b93a67a450640c19f68cd8e77464ffa

Value	Count	Frequency (%)
d576b543eb25443ba0540b652e0d31cb	1384	1.6%
b5495dec57b448b1a7448671d1da2275	1038	1.2%
382dd7483da444d2841eb36023ee0358	880	1.0%
e48ca0799a804a5ba3b361447ad4d602	792	0.9%
4dd0a4d3f47c4a9b966440cc2277b291	791	0.9%
1ff1ed3c2acd4cea9c10b09878cd63fb	682	0.8%
99a5ac38c0fb495fa74a1a803fca8435	674	0.8%
ee702af56c9f42c49677ede02047afcd	655	0.8%
f484b44923e0489eb8582caf5c0b2978	624	0.7%
82213c96be824c9ea6f47d5ae8776bac	618	0.7%
Other values (4561)	76811	90.4%

Most occurring characters

Value	Count	Frequency (%)
4	257726	9.5%
8	182730	6.7%
b	178570	6.6%
a	176546	6.5%
9	173358	6.4%
3	165267	6.1%
7	163434	6.0%
c	163140	6.0%
5	163003	6.0%
d	162461	6.0%
Other values (6)	932133	34.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	257726	9.5%
8	182730	6.7%
b	178570	6.6%
a	176546	6.5%
9	173358	6.4%
3	165267	6.1%
7	163434	6.0%
c	163140	6.0%
5	163003	6.0%
d	162461	6.0%
Other values (6)	932133	34.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	257726	9.5%
8	182730	6.7%
b	178570	6.6%
a	176546	6.5%
9	173358	6.4%
3	165267	6.1%
7	163434	6.0%
c	163140	6.0%
5	163003	6.0%
d	162461	6.0%
Other values (6)	932133	34.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	257726	9.5%
8	182730	6.7%
b	178570	6.6%
a	176546	6.5%
9	173358	6.4%
3	165267	6.1%
7	163434	6.0%
c	163140	6.0%
5	163003	6.0%
d	162461	6.0%
Other values (6)	932133	34.3%

coupon_marketing_flight_number
Real number (ℝ)

Distinct	378
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5308328.6

Minimum	1009781
Maximum	9989525
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1009781
5-th percentile	1327210
Q1	3218088
median	5296004
Q3	7621582
95-th percentile	9342807
Maximum	9989525
Range	8979744
Interquartile range (IQR)	4403494

Descriptive statistics

Standard deviation	2544544.6
Coefficient of variation (CV)	0.47934948
Kurtosis	-1.1807325
Mean	5308328.6
Median Absolute Deviation (MAD)	2186885
Skewness	0.01907752
Sum	4.5093721 × 10¹¹
Variance	6.4747071 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1327210	1374	1.6%
2609995	1201	1.4%
7648128	1197	1.4%
1487938	1030	1.2%
5609032	999	1.2%
4286531	961	1.1%
3297471	921	1.1%
7127217	887	1.0%
4547752	798	0.9%
1299755	795	0.9%
Other values (368)	74786	88.0%

Value	Count	Frequency (%)
1009781	65	0.1%
1156936	473	0.6%
1158981	10	< 0.1%
1160696	157	0.2%
1208037	85	0.1%
1236303	188	0.2%
1252531	316	0.4%
1254679	239	0.3%
1265721	152	0.2%
1271872	388	0.5%

Value	Count	Frequency (%)
9989525	273	0.3%
9959105	253	0.3%
9951897	95	0.1%
9950251	248	0.3%
9949418	421	0.5%
9938466	106	0.1%
9903518	1	< 0.1%
9868778	116	0.1%
9850913	66	0.1%
9675329	408	0.5%

coupon_miles
Real number (ℝ)

High correlation

Distinct	83
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1545.8341

Minimum	-9999
Maximum	6003
Zeros	0
Zeros (%)	0.0%
Negative	132
Negative (%)	0.2%
Memory size	663.8 KiB

Quantile statistics

Minimum	-9999
5-th percentile	316
Q1	531
median	714
Q3	1588
95-th percentile	4801
Maximum	6003
Range	16002
Interquartile range (IQR)	1057

Descriptive statistics

Standard deviation	1708.4085
Coefficient of variation (CV)	1.1051694
Kurtosis	3.0896876
Mean	1545.8341
Median Absolute Deviation (MAD)	232
Skewness	0.77299674
Sum	1.3131706 × 10⁸
Variance	2918659.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
912	4743	5.6%
4255	3409	4.0%
685	3336	3.9%
4309	2736	3.2%
4673	2666	3.1%
246	2549	3.0%
712	2416	2.8%
574	2271	2.7%
835	2207	2.6%
323	2169	2.6%
Other values (73)	56447	66.4%

Value	Count	Frequency (%)
-9999	132	0.2%
211	131	0.2%
242	311	0.4%
246	2549	3.0%
316	1146	1.3%
323	2169	2.6%
334	1377	1.6%
341	897	1.1%
350	1109	1.3%
356	116	0.1%

Value	Count	Frequency (%)
6003	1392	1.6%
5353	1118	1.3%
5276	1230	1.4%
5056	309	0.4%
4985	164	0.2%
4801	881	1.0%
4726	899	1.1%
4673	2666	3.1%
4381	188	0.2%
4315	112	0.1%

coupon_number
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6027734

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	6
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.81292754
Coefficient of variation (CV)	0.50720054
Kurtosis	1.798903
Mean	1.6027734
Median Absolute Deviation (MAD)	0
Skewness	1.4466719
Sum	136154
Variance	0.66085119
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	47195	55.6%
2	28624	33.7%
3	4921	5.8%
4	4112	4.8%
5	82	0.1%
6	15	< 0.1%

Value	Count	Frequency (%)
1	47195	55.6%
2	28624	33.7%
3	4921	5.8%
4	4112	4.8%
5	82	0.1%
6	15	< 0.1%

Value	Count	Frequency (%)
6	15	< 0.1%
5	82	0.1%
4	4112	4.8%
3	4921	5.8%
2	28624	33.7%
1	47195	55.6%

coupon_origin_airport_code
Text

Distinct	80
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	254847
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TBS
2nd row	WAW
3rd row	BEG
4th row	WAW
5th row	OSL

Value	Count	Frequency (%)
waw	41416	48.8%
lhr	2314	2.7%
vno	1692	2.0%
ord	1634	1.9%
jfk	1558	1.8%
ams	1530	1.8%
yyz	1264	1.5%
bru	1196	1.4%
otp	1152	1.4%
prg	1084	1.3%
Other values (70)	30109	35.4%

Most occurring characters

Value	Count	Frequency (%)
W	83753	32.9%
A	49490	19.4%
R	13642	5.4%
L	8637	3.4%
O	8211	3.2%
S	6994	2.7%
D	6716	2.6%
T	6489	2.5%
C	6203	2.4%
N	5486	2.2%
Other values (16)	59226	23.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	83753	32.9%
A	49490	19.4%
R	13642	5.4%
L	8637	3.4%
O	8211	3.2%
S	6994	2.7%
D	6716	2.6%
T	6489	2.5%
C	6203	2.4%
N	5486	2.2%
Other values (16)	59226	23.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	83753	32.9%
A	49490	19.4%
R	13642	5.4%
L	8637	3.4%
O	8211	3.2%
S	6994	2.7%
D	6716	2.6%
T	6489	2.5%
C	6203	2.4%
N	5486	2.2%
Other values (16)	59226	23.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	83753	32.9%
A	49490	19.4%
R	13642	5.4%
L	8637	3.4%
O	8211	3.2%
S	6994	2.7%
D	6716	2.6%
T	6489	2.5%
C	6203	2.4%
N	5486	2.2%
Other values (16)	59226	23.2%

coupon_range
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	83
Missing (%)	0.1%
Memory size	4.1 MiB

SH	66652
LH	18194
MH	16
DOM	4

Length

Max length	3
Median length	2
Mean length	2.0000471
Min length	2

Characters and Unicode

Total characters	169736
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SH
2nd row	LH
3rd row	SH
4th row	LH
5th row	SH

Common Values

Value	Count	Frequency (%)
SH	66652	78.5%
LH	18194	21.4%
MH	16	< 0.1%
DOM	4	< 0.1%
(Missing)	83	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sh	66652	78.5%
lh	18194	21.4%
mh	16	< 0.1%
dom	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
H	84862	50.0%
S	66652	39.3%
L	18194	10.7%
M	20	< 0.1%
D	4	< 0.1%
O	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	169736	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
H	84862	50.0%
S	66652	39.3%
L	18194	10.7%
M	20	< 0.1%
D	4	< 0.1%
O	4	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	169736	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
H	84862	50.0%
S	66652	39.3%
L	18194	10.7%
M	20	< 0.1%
D	4	< 0.1%
O	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	169736	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
H	84862	50.0%
S	66652	39.3%
L	18194	10.7%
M	20	< 0.1%
D	4	< 0.1%
O	4	< 0.1%

coupon_rbd_code
Categorical

High correlation

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

05aa66ad90564e9caf593f69bf0df44c	12620
06461e5ef0bb4941995dadba33f4b58a	12535
5b4d18c017084084b2c8e3860625237e	12354
b6460aef6f204ba8940329aa9f7f99cd	10914
22da46f1ddc1406e8e6aa78cdf573c16	9298
Other values (19)	27228

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	2718368
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	b6460aef6f204ba8940329aa9f7f99cd
2nd row	5b4d18c017084084b2c8e3860625237e
3rd row	fcd7f2fe3e034355bcc3fff350b5c928
4th row	06461e5ef0bb4941995dadba33f4b58a
5th row	fcd7f2fe3e034355bcc3fff350b5c928

Common Values

Value	Count	Frequency (%)
05aa66ad90564e9caf593f69bf0df44c	12620	14.9%
06461e5ef0bb4941995dadba33f4b58a	12535	14.8%
5b4d18c017084084b2c8e3860625237e	12354	14.5%
b6460aef6f204ba8940329aa9f7f99cd	10914	12.8%
22da46f1ddc1406e8e6aa78cdf573c16	9298	10.9%
ebfd18e17bd1415eaa2aed61ea147c7b	8523	10.0%
fcd7f2fe3e034355bcc3fff350b5c928	6054	7.1%
6279682d7eab443facc4f8d077e5d4d2	4217	5.0%
b83de1e4d0124e4da7fddad09c0d6f2c	2585	3.0%
14564119eaff427699aadaa8c262d981	1677	2.0%
Other values (14)	4172	4.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
05aa66ad90564e9caf593f69bf0df44c	12620	14.9%
06461e5ef0bb4941995dadba33f4b58a	12535	14.8%
5b4d18c017084084b2c8e3860625237e	12354	14.5%
b6460aef6f204ba8940329aa9f7f99cd	10914	12.8%
22da46f1ddc1406e8e6aa78cdf573c16	9298	10.9%
ebfd18e17bd1415eaa2aed61ea147c7b	8523	10.0%
fcd7f2fe3e034355bcc3fff350b5c928	6054	7.1%
6279682d7eab443facc4f8d077e5d4d2	4217	5.0%
b83de1e4d0124e4da7fddad09c0d6f2c	2585	3.0%
14564119eaff427699aadaa8c262d981	1677	2.0%
Other values (14)	4172	4.9%

Most occurring characters

Value	Count	Frequency (%)
4	239739	8.8%
a	225136	8.3%
f	206933	7.6%
6	202126	7.4%
d	194013	7.1%
0	184453	6.8%
e	177581	6.5%
9	170655	6.3%
b	161936	6.0%
5	158471	5.8%
Other values (6)	797325	29.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	239739	8.8%
a	225136	8.3%
f	206933	7.6%
6	202126	7.4%
d	194013	7.1%
0	184453	6.8%
e	177581	6.5%
9	170655	6.3%
b	161936	6.0%
5	158471	5.8%
Other values (6)	797325	29.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	239739	8.8%
a	225136	8.3%
f	206933	7.6%
6	202126	7.4%
d	194013	7.1%
0	184453	6.8%
e	177581	6.5%
9	170655	6.3%
b	161936	6.0%
5	158471	5.8%
Other values (6)	797325	29.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	239739	8.8%
a	225136	8.3%
f	206933	7.6%
6	202126	7.4%
d	194013	7.1%
0	184453	6.8%
e	177581	6.5%
9	170655	6.3%
b	161936	6.0%
5	158471	5.8%
Other values (6)	797325	29.3%

email
Text

Distinct	78461
Distinct (%)	92.4%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	2718368
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	72862 ?
Unique (%)	85.8%

Sample

1st row	4a0d5a2fe1974c1f8e8082afa8bdd72b
2nd row	eb3f322048494f7ea59d63bb636772c8
3rd row	93fe4d004f074298ae540784f5466926
4th row	a9a8894fee5d44da923224e46a280e9c
5th row	7e7a981bfcff46aa9077f2dd2803ac57

Value	Count	Frequency (%)
e33ffa74e7434baeb477b7439a0b7c4f	11	< 0.1%
a137146494704591a3b9c63ec4535497	9	< 0.1%
56fe73d8898a485da07de143a35bda4e	9	< 0.1%
6d9548f90748425f85eb3145cb8f72a0	8	< 0.1%
f740d3077d5d4081ab05c37550fb9d38	8	< 0.1%
8a92239cf35142bbbded084f20526b50	8	< 0.1%
5fd440d299ca472c9dd168dd8dec02f9	8	< 0.1%
a01224c98a50439a9f14a307649d8611	8	< 0.1%
bd467efbd63644b390ecc9888fa6f549	7	< 0.1%
dc1fa8efaef240df945096e8652d859a	7	< 0.1%
Other values (78451)	84866	99.9%

Most occurring characters

Value	Count	Frequency (%)
4	244785	9.0%
8	181055	6.7%
b	180507	6.6%
9	180430	6.6%
a	179733	6.6%
5	159884	5.9%
7	159596	5.9%
6	159477	5.9%
1	159311	5.9%
0	159305	5.9%
Other values (6)	954285	35.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	244785	9.0%
8	181055	6.7%
b	180507	6.6%
9	180430	6.6%
a	179733	6.6%
5	159884	5.9%
7	159596	5.9%
6	159477	5.9%
1	159311	5.9%
0	159305	5.9%
Other values (6)	954285	35.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	244785	9.0%
8	181055	6.7%
b	180507	6.6%
9	180430	6.6%
a	179733	6.6%
5	159884	5.9%
7	159596	5.9%
6	159477	5.9%
1	159311	5.9%
0	159305	5.9%
Other values (6)	954285	35.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	244785	9.0%
8	181055	6.7%
b	180507	6.6%
9	180430	6.6%
a	179733	6.6%
5	159884	5.9%
7	159596	5.9%
6	159477	5.9%
1	159311	5.9%
0	159305	5.9%
Other values (6)	954285	35.1%

flight_coupon_id
Real number (ℝ)

Distinct	84801
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5512027.7

Minimum	1000251
Maximum	9999912
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1000251
5-th percentile	1454788.4
Q1	3267038
median	5515807
Q3	7772667
95-th percentile	9556895.2
Maximum	9999912
Range	8999661
Interquartile range (IQR)	4505629

Descriptive statistics

Standard deviation	2601157.5
Coefficient of variation (CV)	0.47190573
Kurtosis	-1.203918
Mean	5512027.7
Median Absolute Deviation (MAD)	2252612
Skewness	-0.002003187
Sum	4.6824125 × 10¹¹
Variance	6.7660203 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2721744	3	< 0.1%
2900124	3	< 0.1%
9811869	2	< 0.1%
9579095	2	< 0.1%
8874794	2	< 0.1%
8918055	2	< 0.1%
9990696	2	< 0.1%
1313193	2	< 0.1%
9651429	2	< 0.1%
9355764	2	< 0.1%
Other values (84791)	84927	> 99.9%

Value	Count	Frequency (%)
1000251	1	< 0.1%
1000624	1	< 0.1%
1000688	1	< 0.1%
1000790	1	< 0.1%
1000843	1	< 0.1%
1000857	1	< 0.1%
1000895	1	< 0.1%
1000967	1	< 0.1%
1001110	1	< 0.1%
1001261	1	< 0.1%

Value	Count	Frequency (%)
9999912	1	< 0.1%
9999846	1	< 0.1%
9999781	1	< 0.1%
9999708	1	< 0.1%
9999669	1	< 0.1%
9999629	1	< 0.1%
9999599	1	< 0.1%
9999588	1	< 0.1%
9999484	1	< 0.1%
9999457	1	< 0.1%

flight_leg_id
Real number (ℝ)

Distinct	84782
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5516877.9

Minimum	1000077
Maximum	9999791
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1000077
5-th percentile	1455697.6
Q1	3270782
median	5525110
Q3	7758842
95-th percentile	9552604.8
Maximum	9999791
Range	8999714
Interquartile range (IQR)	4488060

Descriptive statistics

Standard deviation	2595148.5
Coefficient of variation (CV)	0.47040166
Kurtosis	-1.1977262
Mean	5516877.9
Median Absolute Deviation (MAD)	2244565
Skewness	-0.013353815
Sum	4.6865326 × 10¹¹
Variance	6.734796 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6960253	3	< 0.1%
8118766	3	< 0.1%
2900072	2	< 0.1%
6517808	2	< 0.1%
6846697	2	< 0.1%
7925363	2	< 0.1%
4319337	2	< 0.1%
8863313	2	< 0.1%
7883876	2	< 0.1%
4219254	2	< 0.1%
Other values (84772)	84927	> 99.9%

Value	Count	Frequency (%)
1000077	1	< 0.1%
1000190	1	< 0.1%
1000207	1	< 0.1%
1000357	1	< 0.1%
1000406	1	< 0.1%
1000412	1	< 0.1%
1000561	1	< 0.1%
1000615	1	< 0.1%
1000673	1	< 0.1%
1000786	1	< 0.1%

Value	Count	Frequency (%)
9999791	1	< 0.1%
9999680	1	< 0.1%
9999622	1	< 0.1%
9999574	1	< 0.1%
9999565	1	< 0.1%
9999461	1	< 0.1%
9999445	1	< 0.1%
9999321	1	< 0.1%
9999209	1	< 0.1%
9998966	1	< 0.1%

is_seat
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

0	53368
1	31581

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	53368	62.8%
1	31581	37.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	53368	62.8%
1	31581	37.2%

Most occurring characters

Value	Count	Frequency (%)
0	53368	62.8%
1	31581	37.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	53368	62.8%
1	31581	37.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	53368	62.8%
1	31581	37.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	53368	62.8%
1	31581	37.2%

leg_arrival_hour
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.747931

Minimum	0
Maximum	23
Zeros	820
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	11
median	16
Q3	19
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.3561062
Coefficient of variation (CV)	0.36317678
Kurtosis	-0.273186
Mean	14.747931
Median Absolute Deviation (MAD)	4
Skewness	-0.59319882
Sum	1252822
Variance	28.687873
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
9	8824	10.4%
13	7692	9.1%
18	7597	8.9%
19	6989	8.2%
17	6695	7.9%
21	6219	7.3%
12	6145	7.2%
22	5337	6.3%
20	5040	5.9%
14	3884	4.6%
Other values (14)	20527	24.2%

Value	Count	Frequency (%)
0	820	1.0%
1	1094	1.3%
2	734	0.9%
3	316	0.4%
4	1034	1.2%
5	986	1.2%
6	1594	1.9%
7	649	0.8%
8	1658	2.0%
9	8824	10.4%

Value	Count	Frequency (%)
23	1453	1.7%
22	5337	6.3%
21	6219	7.3%
20	5040	5.9%
19	6989	8.2%
18	7597	8.9%
17	6695	7.9%
16	3410	4.0%
15	3157	3.7%
14	3884	4.6%

leg_arrival_timezone_code
Text

Distinct	52
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.1 MiB

Length

Max length	19
Median length	13
Mean length	13.532155
Min length	9

Characters and Unicode

Total characters	1149543
Distinct characters	45
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Europe/Warsaw
2nd row	America/New_York
3rd row	Europe/Warsaw
4th row	Asia/Kolkata
5th row	Europe/Bucharest

Value	Count	Frequency (%)
europe/warsaw	32045	37.7%
europe/berlin	4020	4.7%
america/new_york	3773	4.4%
europe/london	3051	3.6%
europe/vilnius	2312	2.7%
america/chicago	2157	2.5%
europe/zurich	2126	2.5%
europe/amsterdam	2087	2.5%
europe/paris	1950	2.3%
europe/bucharest	1901	2.2%
Other values (42)	29527	34.8%

Most occurring characters

Value	Count	Frequency (%)
r	137263	11.9%
e	107219	9.3%
a	106718	9.3%
o	101734	8.8%
u	85275	7.4%
/	84949	7.4%
p	72624	6.3%
E	69896	6.1%
s	58511	5.1%
i	41130	3.6%
Other values (35)	284224	24.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1149543	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	137263	11.9%
e	107219	9.3%
a	106718	9.3%
o	101734	8.8%
u	85275	7.4%
/	84949	7.4%
p	72624	6.3%
E	69896	6.1%
s	58511	5.1%
i	41130	3.6%
Other values (35)	284224	24.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1149543	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	137263	11.9%
e	107219	9.3%
a	106718	9.3%
o	101734	8.8%
u	85275	7.4%
/	84949	7.4%
p	72624	6.3%
E	69896	6.1%
s	58511	5.1%
i	41130	3.6%
Other values (35)	284224	24.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1149543	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	137263	11.9%
e	107219	9.3%
a	106718	9.3%
o	101734	8.8%
u	85275	7.4%
/	84949	7.4%
p	72624	6.3%
E	69896	6.1%
s	58511	5.1%
i	41130	3.6%
Other values (35)	284224	24.7%

leg_departure_hour
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.763505

Minimum	0
Maximum	23
Zeros	18
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	14
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.0518301
Coefficient of variation (CV)	0.36704531
Kurtosis	-1.0384471
Mean	13.763505
Median Absolute Deviation (MAD)	4
Skewness	-0.11599134
Sum	1169196
Variance	25.520987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
10	8910	10.5%
19	8420	9.9%
7	7730	9.1%
14	6902	8.1%
17	6478	7.6%
16	6303	7.4%
18	4993	5.9%
22	4285	5.0%
12	3996	4.7%
8	3732	4.4%
Other values (14)	23200	27.3%

Value	Count	Frequency (%)
0	18	< 0.1%
1	251	0.3%
2	55	0.1%
3	321	0.4%
4	273	0.3%
5	2647	3.1%
6	1955	2.3%
7	7730	9.1%
8	3732	4.4%
9	2505	2.9%

Value	Count	Frequency (%)
23	1256	1.5%
22	4285	5.0%
21	1678	2.0%
20	3175	3.7%
19	8420	9.9%
18	4993	5.9%
17	6478	7.6%
16	6303	7.4%
15	3448	4.1%
14	6902	8.1%

leg_departure_month
Real number (ℝ)

High correlation

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.4200873

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	9
median	9
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	3.3561857
Coefficient of variation (CV)	0.39859274
Kurtosis	0.12347817
Mean	8.4200873
Median Absolute Deviation (MAD)	1
Skewness	-1.2618251
Sum	715278
Variance	11.263982
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
9	24732	29.1%
10	23219	27.3%
11	10909	12.8%
12	8322	9.8%
2	7470	8.8%
1	5042	5.9%
3	4277	5.0%
8	978	1.2%

Value	Count	Frequency (%)
1	5042	5.9%
2	7470	8.8%
3	4277	5.0%
8	978	1.2%
9	24732	29.1%
10	23219	27.3%
11	10909	12.8%
12	8322	9.8%

Value	Count	Frequency (%)
12	8322	9.8%
11	10909	12.8%
10	23219	27.3%
9	24732	29.1%
8	978	1.2%
3	4277	5.0%
2	7470	8.8%
1	5042	5.9%

leg_departure_timezone_code
Text

Distinct	52
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.1 MiB

Length

Max length	19
Median length	13
Mean length	13.507281
Min length	9

Characters and Unicode

Total characters	1147430
Distinct characters	45
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Asia/Tbilisi
2nd row	Europe/Warsaw
3rd row	Europe/Belgrade
4th row	Europe/Warsaw
5th row	Europe/Oslo

Value	Count	Frequency (%)
europe/warsaw	33380	39.3%
europe/berlin	3828	4.5%
america/new_york	3192	3.8%
europe/london	2817	3.3%
europe/vilnius	2583	3.0%
europe/bucharest	2037	2.4%
europe/zurich	1849	2.2%
america/chicago	1829	2.2%
europe/paris	1787	2.1%
europe/amsterdam	1747	2.1%
Other values (42)	29900	35.2%

Most occurring characters

Value	Count	Frequency (%)
r	137280	12.0%
a	108478	9.5%
e	106334	9.3%
o	100964	8.8%
u	86856	7.6%
/	84949	7.4%
p	74077	6.5%
E	71354	6.2%
s	59466	5.2%
i	40236	3.5%
Other values (35)	277436	24.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1147430	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	137280	12.0%
a	108478	9.5%
e	106334	9.3%
o	100964	8.8%
u	86856	7.6%
/	84949	7.4%
p	74077	6.5%
E	71354	6.2%
s	59466	5.2%
i	40236	3.5%
Other values (35)	277436	24.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1147430	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	137280	12.0%
a	108478	9.5%
e	106334	9.3%
o	100964	8.8%
u	86856	7.6%
/	84949	7.4%
p	74077	6.5%
E	71354	6.2%
s	59466	5.2%
i	40236	3.5%
Other values (35)	277436	24.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1147430	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	137280	12.0%
a	108478	9.5%
e	106334	9.3%
o	100964	8.8%
u	86856	7.6%
/	84949	7.4%
p	74077	6.5%
E	71354	6.2%
s	59466	5.2%
i	40236	3.5%
Other values (35)	277436	24.2%

leg_destination_airport_code
Text

Distinct	87
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	254847
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WAW
2nd row	EWR
3rd row	SZZ
4th row	BOM
5th row	OTP

Value	Count	Frequency (%)
waw	27264	32.1%
lhr	2662	3.1%
vno	2312	2.7%
ord	2157	2.5%
ams	2087	2.5%
jfk	2085	2.5%
yyz	1861	2.2%
krk	1820	2.1%
otp	1536	1.8%
prg	1451	1.7%
Other values (77)	39714	46.8%

Most occurring characters

Value	Count	Frequency (%)
W	56496	22.2%
A	37465	14.7%
R	18683	7.3%
O	11409	4.5%
L	10681	4.2%
D	8944	3.5%
T	8303	3.3%
S	8116	3.2%
N	7800	3.1%
C	7744	3.0%
Other values (16)	79206	31.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	56496	22.2%
A	37465	14.7%
R	18683	7.3%
O	11409	4.5%
L	10681	4.2%
D	8944	3.5%
T	8303	3.3%
S	8116	3.2%
N	7800	3.1%
C	7744	3.0%
Other values (16)	79206	31.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	56496	22.2%
A	37465	14.7%
R	18683	7.3%
O	11409	4.5%
L	10681	4.2%
D	8944	3.5%
T	8303	3.3%
S	8116	3.2%
N	7800	3.1%
C	7744	3.0%
Other values (16)	79206	31.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	56496	22.2%
A	37465	14.7%
R	18683	7.3%
O	11409	4.5%
L	10681	4.2%
D	8944	3.5%
T	8303	3.3%
S	8116	3.2%
N	7800	3.1%
C	7744	3.0%
Other values (16)	79206	31.1%

leg_destination_country_code
Categorical

High correlation Missing

Distinct	45
Distinct (%)	0.2%
Missing	65106
Missing (%)	76.6%
Memory size	4.4 MiB

PL	8932
US	2281
DE	744
IT	679
CH	608
Other values (40)	6599

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	39686
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	US
2nd row	PL
3rd row	PL
4th row	DK
5th row	CZ

Common Values

Value	Count	Frequency (%)
PL	8932	10.5%
US	2281	2.7%
DE	744	0.9%
IT	679	0.8%
CH	608	0.7%
GB	561	0.7%
NL	524	0.6%
FR	511	0.6%
ES	435	0.5%
TR	434	0.5%
Other values (35)	4134	4.9%
(Missing)	65106	76.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pl	8932	45.0%
us	2281	11.5%
de	744	3.7%
it	679	3.4%
ch	608	3.1%
gb	561	2.8%
nl	524	2.6%
fr	511	2.6%
es	435	2.2%
tr	434	2.2%
Other values (35)	4134	20.8%

Most occurring characters

Value	Count	Frequency (%)
L	9783	24.7%
P	9216	23.2%
S	3041	7.7%
U	2543	6.4%
E	2253	5.7%
R	1639	4.1%
T	1344	3.4%
G	1177	3.0%
C	1154	2.9%
B	1007	2.5%
Other values (13)	6529	16.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	39686	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	9783	24.7%
P	9216	23.2%
S	3041	7.7%
U	2543	6.4%
E	2253	5.7%
R	1639	4.1%
T	1344	3.4%
G	1177	3.0%
C	1154	2.9%
B	1007	2.5%
Other values (13)	6529	16.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	39686	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	9783	24.7%
P	9216	23.2%
S	3041	7.7%
U	2543	6.4%
E	2253	5.7%
R	1639	4.1%
T	1344	3.4%
G	1177	3.0%
C	1154	2.9%
B	1007	2.5%
Other values (13)	6529	16.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	39686	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	9783	24.7%
P	9216	23.2%
S	3041	7.7%
U	2543	6.4%
E	2253	5.7%
R	1639	4.1%
T	1344	3.4%
G	1177	3.0%
C	1154	2.9%
B	1007	2.5%
Other values (13)	6529	16.5%

leg_duration_h
Real number (ℝ)

Zeros

Distinct	45
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.8904755

Minimum	0
Maximum	45
Zeros	3115
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	18
Maximum	45
Range	45
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	5.4787245
Coefficient of variation (CV)	1.1202846
Kurtosis	4.4896323
Mean	4.8904755
Median Absolute Deviation (MAD)	2
Skewness	2.0912358
Sum	415441
Variance	30.016422
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
1	17585	20.7%
2	16889	19.9%
3	13704	16.1%
4	7083	8.3%
5	5352	6.3%
6	3564	4.2%
0	3115	3.7%
14	2866	3.4%
7	2369	2.8%
16	1614	1.9%
Other values (35)	10808	12.7%

Value	Count	Frequency (%)
0	3115	3.7%
1	17585	20.7%
2	16889	19.9%
3	13704	16.1%
4	7083	8.3%
5	5352	6.3%
6	3564	4.2%
7	2369	2.8%
8	1377	1.6%
9	1251	1.5%

Value	Count	Frequency (%)
45	1	< 0.1%
43	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
40	1	< 0.1%
39	6	< 0.1%
38	4	< 0.1%
37	3	< 0.1%
36	4	< 0.1%
35	36	< 0.1%

leg_first_leg_flg
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

1	53664
0	31285

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	53664	63.2%
0	31285	36.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	53664	63.2%
0	31285	36.8%

Most occurring characters

Value	Count	Frequency (%)
1	53664	63.2%
0	31285	36.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	53664	63.2%
0	31285	36.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	53664	63.2%
0	31285	36.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	53664	63.2%
0	31285	36.8%

leg_hours_to_departure
Real number (ℝ)

High correlation

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.753111

Minimum	61
Maximum	80
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	61
5-th percentile	65
Q1	71
median	71
Q3	71
95-th percentile	73
Maximum	80
Range	19
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.2920686
Coefficient of variation (CV)	0.032395305
Kurtosis	5.0003351
Mean	70.753111
Median Absolute Deviation (MAD)	0
Skewness	-1.1170164
Sum	6010406
Variance	5.2535785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
71	55888	65.8%
72	10344	12.2%
70	5579	6.6%
65	4543	5.3%
64	1687	2.0%
74	1571	1.8%
73	1302	1.5%
78	1100	1.3%
75	935	1.1%
62	593	0.7%
Other values (8)	1407	1.7%

Value	Count	Frequency (%)
61	103	0.1%
62	593	0.7%
63	79	0.1%
64	1687	2.0%
65	4543	5.3%
66	329	0.4%
69	337	0.4%
70	5579	6.6%
71	55888	65.8%
72	10344	12.2%

Value	Count	Frequency (%)
80	21	< 0.1%
79	314	0.4%
78	1100	1.3%
77	69	0.1%
76	155	0.2%
75	935	1.1%
74	1571	1.8%
73	1302	1.5%
72	10344	12.2%
71	55888	65.8%

leg_last_leg_flg
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

1	54020
0	30929

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	54020	63.6%
0	30929	36.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	54020	63.6%
0	30929	36.4%

Most occurring characters

Value	Count	Frequency (%)
1	54020	63.6%
0	30929	36.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	54020	63.6%
0	30929	36.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	54020	63.6%
0	30929	36.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	54020	63.6%
0	30929	36.4%

leg_number
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

1	57564
2	27305
3	80

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	57564	67.8%
2	27305	32.1%
3	80	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	57564	67.8%
2	27305	32.1%
3	80	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	57564	67.8%
2	27305	32.1%
3	80	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	57564	67.8%
2	27305	32.1%
3	80	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	57564	67.8%
2	27305	32.1%
3	80	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	57564	67.8%
2	27305	32.1%
3	80	0.1%

leg_origin_airport_code
Text

Distinct	87
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	254847
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TBS
2nd row	WAW
3rd row	BEG
4th row	WAW
5th row	OSL

Value	Count	Frequency (%)
waw	28484	33.5%
vno	2583	3.0%
lhr	2472	2.9%
krk	1873	2.2%
ord	1829	2.2%
ams	1747	2.1%
jfk	1707	2.0%
otp	1599	1.9%
tll	1579	1.9%
yyz	1565	1.8%
Other values (77)	39511	46.5%

Most occurring characters

Value	Count	Frequency (%)
W	58868	23.1%
A	38077	14.9%
R	18022	7.1%
O	11721	4.6%
L	10867	4.3%
T	8828	3.5%
D	8499	3.3%
S	8454	3.3%
N	7836	3.1%
C	7217	2.8%
Other values (16)	76458	30.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	58868	23.1%
A	38077	14.9%
R	18022	7.1%
O	11721	4.6%
L	10867	4.3%
T	8828	3.5%
D	8499	3.3%
S	8454	3.3%
N	7836	3.1%
C	7217	2.8%
Other values (16)	76458	30.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	58868	23.1%
A	38077	14.9%
R	18022	7.1%
O	11721	4.6%
L	10867	4.3%
T	8828	3.5%
D	8499	3.3%
S	8454	3.3%
N	7836	3.1%
C	7217	2.8%
Other values (16)	76458	30.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	254847	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	58868	23.1%
A	38077	14.9%
R	18022	7.1%
O	11721	4.6%
L	10867	4.3%
T	8828	3.5%
D	8499	3.3%
S	8454	3.3%
N	7836	3.1%
C	7217	2.8%
Other values (16)	76458	30.0%

leg_origin_country_code
Categorical

High correlation Missing

Distinct	44
Distinct (%)	0.2%
Missing	65079
Missing (%)	76.6%
Memory size	4.4 MiB

PL	10611
US	1956
DE	673
IT	519
GB	466
Other values (39)	5645

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	39740
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ES
2nd row	KR
3rd row	PL
4th row	PL
5th row	CH

Common Values

Value	Count	Frequency (%)
PL	10611	12.5%
US	1956	2.3%
DE	673	0.8%
IT	519	0.6%
GB	466	0.5%
CH	460	0.5%
FR	443	0.5%
ES	388	0.5%
NL	385	0.5%
TR	345	0.4%
Other values (34)	3624	4.3%
(Missing)	65079	76.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pl	10611	53.4%
us	1956	9.8%
de	673	3.4%
it	519	2.6%
gb	466	2.3%
ch	460	2.3%
fr	443	2.2%
es	388	2.0%
nl	385	1.9%
tr	345	1.7%
Other values (34)	3624	18.2%

Most occurring characters

Value	Count	Frequency (%)
L	11259	28.3%
P	10793	27.2%
S	2662	6.7%
U	2191	5.5%
E	2003	5.0%
R	1442	3.6%
T	1058	2.7%
G	994	2.5%
C	885	2.2%
D	874	2.2%
Other values (13)	5579	14.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	39740	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	11259	28.3%
P	10793	27.2%
S	2662	6.7%
U	2191	5.5%
E	2003	5.0%
R	1442	3.6%
T	1058	2.7%
G	994	2.5%
C	885	2.2%
D	874	2.2%
Other values (13)	5579	14.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	39740	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	11259	28.3%
P	10793	27.2%
S	2662	6.7%
U	2191	5.5%
E	2003	5.0%
R	1442	3.6%
T	1058	2.7%
G	994	2.5%
C	885	2.2%
D	874	2.2%
Other values (13)	5579	14.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	39740	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	11259	28.3%
P	10793	27.2%
S	2662	6.7%
U	2191	5.5%
E	2003	5.0%
R	1442	3.6%
T	1058	2.7%
G	994	2.5%
C	885	2.2%
D	874	2.2%
Other values (13)	5579	14.0%

leg_stopover_time_h
Real number (ℝ)

High correlation

Distinct	2031
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-6240.4644

Minimum	-9999
Maximum	8771
Zeros	0
Zeros (%)	0.0%
Negative	54020
Negative (%)	63.6%
Memory size	663.8 KiB

Quantile statistics

Minimum	-9999
5-th percentile	-9999
Q1	-9999
median	-9999
Q3	99
95-th percentile	492
Maximum	8771
Range	18770
Interquartile range (IQR)	10098

Descriptive statistics

Standard deviation	4980.8746
Coefficient of variation (CV)	-0.79815767
Kurtosis	-1.6120766
Mean	-6240.4644
Median Absolute Deviation (MAD)	0
Skewness	0.58604442
Sum	-5.3012121 × 10⁸
Variance	24809111
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-9999	54020	63.6%
75	479	0.6%
84	393	0.5%
74	392	0.5%
99	351	0.4%
79	287	0.3%
51	285	0.3%
76	285	0.3%
77	280	0.3%
108	260	0.3%
Other values (2021)	27917	32.9%

Value	Count	Frequency (%)
-9999	54020	63.6%
3	1	< 0.1%
6	1	< 0.1%
7	5	< 0.1%
8	5	< 0.1%
9	7	< 0.1%
10	17	< 0.1%
11	8	< 0.1%
12	25	< 0.1%
13	13	< 0.1%

Value	Count	Frequency (%)
8771	1	< 0.1%
8616	1	< 0.1%
8602	1	< 0.1%
8555	1	< 0.1%
8412	1	< 0.1%
8411	1	< 0.1%
8290	1	< 0.1%
8214	1	< 0.1%
8127	1	< 0.1%
8117	1	< 0.1%

pnr
Text

Distinct	81730
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	2718368
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	78610 ?
Unique (%)	92.5%

Sample

1st row	40faefe514be47b38cea3be065583d7f
2nd row	7fafefddde544aba95c69552cfbadd51
3rd row	6240c081718e4439a3174ac38a2c9c45
4th row	231c99e3d0644366827e91276296e3cc
5th row	4854301527cf48f7a32c9625a154874b

Value	Count	Frequency (%)
7bbdfd259c424672aaec55b4ed21012b	11	< 0.1%
3fd51e95bf884d2d9b0950c2bc674127	7	< 0.1%
9846d8372bc34bfc8c49f0ea00a4a2c5	6	< 0.1%
8a67aa5b47a842a9b56fc29e30c65a41	5	< 0.1%
35789d3d925a48ac90178695077c1a20	5	< 0.1%
e897a35961fd456b8d8ba989a418e40f	5	< 0.1%
52afcd9f9c9949fcb40987f28572e65c	5	< 0.1%
8f392122ed114131a7f700e24be0bc3b	5	< 0.1%
fb0fe9571e1a492ab5c081a047286fbe	4	< 0.1%
991a40de96464afe8d3d7eef7b76b403	4	< 0.1%
Other values (81720)	84892	99.9%

Most occurring characters

Value	Count	Frequency (%)
4	244297	9.0%
9	180501	6.6%
a	180332	6.6%
b	180247	6.6%
8	179880	6.6%
e	159801	5.9%
7	159637	5.9%
c	159581	5.9%
f	159418	5.9%
1	159357	5.9%
Other values (6)	955317	35.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	244297	9.0%
9	180501	6.6%
a	180332	6.6%
b	180247	6.6%
8	179880	6.6%
e	159801	5.9%
7	159637	5.9%
c	159581	5.9%
f	159418	5.9%
1	159357	5.9%
Other values (6)	955317	35.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	244297	9.0%
9	180501	6.6%
a	180332	6.6%
b	180247	6.6%
8	179880	6.6%
e	159801	5.9%
7	159637	5.9%
c	159581	5.9%
f	159418	5.9%
1	159357	5.9%
Other values (6)	955317	35.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	244297	9.0%
9	180501	6.6%
a	180332	6.6%
b	180247	6.6%
8	179880	6.6%
e	159801	5.9%
7	159637	5.9%
c	159581	5.9%
f	159418	5.9%
1	159357	5.9%
Other values (6)	955317	35.1%

preffered_language
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.4 MiB

en_gb	65438
pl_pl	19511

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	424745
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en_gb
2nd row	en_gb
3rd row	en_gb
4th row	en_gb
5th row	en_gb

Common Values

Value	Count	Frequency (%)
en_gb	65438	77.0%
pl_pl	19511	23.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
en_gb	65438	77.0%
pl_pl	19511	23.0%

Most occurring characters

Value	Count	Frequency (%)
_	84949	20.0%
e	65438	15.4%
n	65438	15.4%
g	65438	15.4%
b	65438	15.4%
p	39022	9.2%
l	39022	9.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	424745	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
_	84949	20.0%
e	65438	15.4%
n	65438	15.4%
g	65438	15.4%
b	65438	15.4%
p	39022	9.2%
l	39022	9.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	424745	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
_	84949	20.0%
e	65438	15.4%
n	65438	15.4%
g	65438	15.4%
b	65438	15.4%
p	39022	9.2%
l	39022	9.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	424745	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
_	84949	20.0%
e	65438	15.4%
n	65438	15.4%
g	65438	15.4%
b	65438	15.4%
p	39022	9.2%
l	39022	9.2%

request_dttm
Date

Distinct	4133
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Memory size	663.8 KiB

Minimum	2013-09-14 19:04:16.417000+00:00
Maximum	2014-03-31 04:12:26.013000+00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

request_id
Text

Distinct	4133
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	2718368
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	169 ?
Unique (%)	0.2%

Sample

1st row	ee37548ce2a74b99b41d67f4d2a138fd
2nd row	f083457969dd46d2ada761198096ecc4
3rd row	9df9a894f4374dfba0d8811dd99c1b1e
4th row	89c95fa040db42d4a1982c7901128585
5th row	d44b65a240374e61867039b37c98f9a0

Value	Count	Frequency (%)
39a540adca3c4aec9af5f90d5b0bfc1d	146	0.2%
000a88383de8468db61e4d1a18c827ef	138	0.2%
7887589e65a344a380c87efcc682456c	117	0.1%
d5a8015576df42048f289bc9d411b80e	115	0.1%
699208e0cce04b66835be483ff63389c	114	0.1%
c39075c74f2345eea9d09d21ca931bb4	112	0.1%
44148fae00a44a1f9edbdb727b8dfdaf	110	0.1%
0770b83e2dd94da685bf6e62e78388db	109	0.1%
cbd63f2c0ddb4a55bb7dfd6302a91a10	108	0.1%
4ceaab8a97274997813ba0135dcf7ec0	108	0.1%
Other values (4123)	83772	98.6%

Most occurring characters

Value	Count	Frequency (%)
4	242452	8.9%
8	183508	6.8%
a	182636	6.7%
9	181797	6.7%
b	180619	6.6%
1	164127	6.0%
2	163027	6.0%
d	159905	5.9%
3	159749	5.9%
5	158988	5.8%
Other values (6)	941560	34.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	242452	8.9%
8	183508	6.8%
a	182636	6.7%
9	181797	6.7%
b	180619	6.6%
1	164127	6.0%
2	163027	6.0%
d	159905	5.9%
3	159749	5.9%
5	158988	5.8%
Other values (6)	941560	34.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	242452	8.9%
8	183508	6.8%
a	182636	6.7%
9	181797	6.7%
b	180619	6.6%
1	164127	6.0%
2	163027	6.0%
d	159905	5.9%
3	159749	5.9%
5	158988	5.8%
Other values (6)	941560	34.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2718368	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	242452	8.9%
8	183508	6.8%
a	182636	6.7%
9	181797	6.7%
b	180619	6.6%
1	164127	6.0%
2	163027	6.0%
d	159905	5.9%
3	159749	5.9%
5	158988	5.8%
Other values (6)	941560	34.6%

clicked
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

0	57089
1	27860

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	57089	67.2%
1	27860	32.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	57089	67.2%
1	27860	32.8%

Most occurring characters

Value	Count	Frequency (%)
0	57089	67.2%
1	27860	32.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	57089	67.2%
1	27860	32.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	57089	67.2%
1	27860	32.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	57089	67.2%
1	27860	32.8%

graphic_design
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

B	34114
A	33890
C	16945

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	B
3rd row	C
4th row	A
5th row	B

Common Values

Value	Count	Frequency (%)
B	34114	40.2%
A	33890	39.9%
C	16945	19.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b	34114	40.2%
a	33890	39.9%
c	16945	19.9%

Most occurring characters

Value	Count	Frequency (%)
B	34114	40.2%
A	33890	39.9%
C	16945	19.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	34114	40.2%
A	33890	39.9%
C	16945	19.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	34114	40.2%
A	33890	39.9%
C	16945	19.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	34114	40.2%
A	33890	39.9%
C	16945	19.9%

top_1_section
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

3	42453
4	17122
1	16956
6	8418

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	84949
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	6
2nd row	4
3rd row	3
4th row	3
5th row	3

Common Values

Value	Count	Frequency (%)
3	42453	50.0%
4	17122	20.2%
1	16956	20.0%
6	8418	9.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	42453	50.0%
4	17122	20.2%
1	16956	20.0%
6	8418	9.9%

Most occurring characters

Value	Count	Frequency (%)
3	42453	50.0%
4	17122	20.2%
1	16956	20.0%
6	8418	9.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	42453	50.0%
4	17122	20.2%
1	16956	20.0%
6	8418	9.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	42453	50.0%
4	17122	20.2%
1	16956	20.0%
6	8418	9.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	42453	50.0%
4	17122	20.2%
1	16956	20.0%
6	8418	9.9%

top_2_section
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4024532

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.4980915
Coefficient of variation (CV)	0.44029744
Kurtosis	-1.0131755
Mean	3.4024532
Median Absolute Deviation (MAD)	1
Skewness	0.19027042
Sum	289035
Variance	2.244278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	25436	29.9%
5	17048	20.1%
2	16947	19.9%
6	8527	10.0%
1	8511	10.0%
4	8480	10.0%

Value	Count	Frequency (%)
1	8511	10.0%
2	16947	19.9%
3	25436	29.9%
4	8480	10.0%
5	17048	20.1%
6	8527	10.0%

Value	Count	Frequency (%)
6	8527	10.0%
5	17048	20.1%
4	8480	10.0%
3	25436	29.9%
2	16947	19.9%
1	8511	10.0%

top_3_section
Real number (ℝ)

High correlation Zeros

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5058211

Minimum	0
Maximum	5
Zeros	16945
Zeros (%)	19.9%
Negative	0
Negative (%)	0.0%
Memory size	663.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.7466911
Coefficient of variation (CV)	0.69705336
Kurtosis	-1.2086607
Mean	2.5058211
Median Absolute Deviation (MAD)	1
Skewness	-0.0051259014
Sum	212867
Variance	3.0509296
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	17066	20.1%
3	17060	20.1%
0	16945	19.9%
2	16943	19.9%
4	8512	10.0%
1	8423	9.9%

Value	Count	Frequency (%)
0	16945	19.9%
1	8423	9.9%
2	16943	19.9%
3	17060	20.1%
4	8512	10.0%
5	17066	20.1%

Value	Count	Frequency (%)
5	17066	20.1%
4	8512	10.0%
3	17060	20.1%
2	16943	19.9%
1	8423	9.9%
0	16945	19.9%

Interactions

Correlations

	booking_adult_count	booking_child_count	booking_id	booking_infant_count	booking_leg_count	booking_original_currency	booking_pax_count	booking_payment_method	booking_reservation_month	booking_sales_channel	booking_segments_count	booking_trip_type	booking_window_w	clicked	coupon_cabin_class	coupon_marketing_flight_number	coupon_miles	coupon_number	coupon_range	coupon_rbd_code	flight_coupon_id	flight_leg_id	graphic_design	id	is_seat	leg_arrival_hour	leg_departure_hour	leg_departure_month	leg_destination_country_code	leg_duration_h	leg_first_leg_flg	leg_hours_to_departure	leg_last_leg_flg	leg_number	leg_origin_country_code	leg_stopover_time_h	preffered_language	top_1_section	top_2_section	top_3_section
booking_adult_count	1.000	0.168	-0.004	0.117	0.014	0.000	0.956	0.072	-0.074	0.093	0.049	0.023	0.231	0.001	0.000	-0.007	0.076	0.029	0.003	0.356	-0.001	-0.005	0.005	-0.035	0.052	-0.017	-0.013	-0.008	0.021	0.044	0.011	0.004	0.011	0.006	0.000	0.033	0.023	0.000	0.003	0.003
booking_child_count	0.168	1.000	-0.005	0.077	0.019	0.015	0.375	0.015	-0.010	0.026	0.021	0.029	0.073	0.024	0.004	-0.013	0.049	0.023	0.008	0.010	-0.003	0.005	0.003	0.028	0.008	0.010	-0.010	0.004	0.031	0.022	0.018	-0.001	0.013	0.021	0.028	0.021	0.027	0.004	0.003	0.007
booking_id	-0.004	-0.005	1.000	0.006	0.003	0.000	-0.004	0.000	0.000	0.003	-0.000	0.000	-0.001	0.007	0.003	-0.000	-0.002	-0.003	0.000	0.001	-0.005	0.004	0.000	-0.006	0.000	-0.003	0.002	0.005	0.003	0.004	0.000	-0.001	0.006	0.002	0.003	-0.002	0.002	0.004	-0.000	-0.002
booking_infant_count	0.117	0.077	0.006	1.000	0.042	0.000	0.121	0.006	0.013	0.027	0.000	0.007	0.009	0.028	0.000	0.011	0.005	0.005	0.000	0.033	0.004	0.000	0.000	0.009	0.015	0.009	0.011	0.005	0.031	0.012	0.011	0.006	0.000	0.020	0.009	0.000	0.003	0.000	0.001	0.004
booking_leg_count	0.014	0.019	0.003	0.042	1.000	0.111	0.014	0.033	0.054	0.069	0.444	0.697	0.062	0.010	0.031	0.033	0.071	0.171	0.068	0.130	0.005	0.005	0.004	0.024	0.050	0.034	0.048	0.021	0.071	0.074	0.464	0.073	0.459	0.482	0.134	0.265	0.129	0.006	0.004	0.005
booking_original_currency	0.000	0.015	0.000	0.000	0.111	1.000	0.007	0.245	0.050	0.283	0.127	0.149	0.043	0.068	0.142	0.147	0.349	0.086	0.322	0.055	0.009	0.005	0.010	0.045	0.162	0.127	0.182	0.054	0.179	0.168	0.079	0.265	0.077	0.075	0.231	0.068	0.592	0.000	0.005	0.010
booking_pax_count	0.956	0.375	-0.004	0.121	0.014	0.007	1.000	0.070	-0.071	0.090	0.048	0.022	0.232	0.004	0.000	-0.010	0.082	0.032	0.005	0.338	-0.002	-0.003	0.007	-0.030	0.050	-0.014	-0.015	-0.006	0.022	0.045	0.009	0.004	0.011	0.008	0.012	0.035	0.022	0.000	0.005	0.004
booking_payment_method	0.072	0.015	0.000	0.006	0.033	0.245	0.070	1.000	0.062	0.137	0.028	0.037	0.064	0.019	0.023	0.026	0.066	0.031	0.065	0.125	0.000	0.000	0.005	0.021	0.053	0.041	0.049	0.016	0.114	0.058	0.022	0.060	0.020	0.034	0.116	0.015	0.087	0.000	0.003	0.000
booking_reservation_month	-0.074	-0.010	0.000	0.013	0.054	0.050	-0.071	0.062	1.000	0.041	-0.022	0.084	-0.246	0.074	0.042	0.014	-0.106	-0.047	0.108	0.059	0.001	0.000	0.000	0.153	0.022	0.011	-0.023	0.528	0.074	-0.051	0.044	0.040	0.043	0.091	0.081	-0.051	0.082	0.000	-0.003	0.001
booking_sales_channel	0.093	0.026	0.003	0.027	0.069	0.283	0.090	0.137	0.041	1.000	0.046	0.095	0.049	0.029	0.066	0.020	0.060	0.026	0.066	0.300	0.003	0.006	0.000	0.020	0.087	0.021	0.039	0.018	0.100	0.045	0.055	0.043	0.051	0.043	0.087	0.030	0.348	0.000	0.001	0.000
booking_segments_count	0.049	0.021	-0.000	0.000	0.444	0.127	0.048	0.028	-0.022	0.046	1.000	0.630	0.055	0.019	0.023	-0.020	-0.019	0.498	0.062	0.067	0.001	0.002	0.005	0.047	0.095	-0.014	-0.060	-0.003	0.078	0.443	0.350	0.090	0.344	0.245	0.114	0.298	0.171	0.003	0.002	-0.003
booking_trip_type	0.023	0.029	0.000	0.007	0.697	0.149	0.022	0.037	0.084	0.095	0.630	1.000	0.100	0.015	0.039	0.039	0.095	0.220	0.089	0.174	0.004	0.004	0.000	0.069	0.042	0.048	0.061	0.064	0.098	0.082	0.446	0.081	0.441	0.293	0.153	0.312	0.144	0.003	0.003	0.000
booking_window_w	0.231	0.073	-0.001	0.009	0.062	0.043	0.232	0.064	-0.246	0.049	0.055	0.100	1.000	0.059	0.073	-0.022	0.163	0.026	0.114	0.103	0.001	0.005	0.000	-0.105	0.035	-0.016	0.031	0.018	0.076	0.101	0.050	-0.054	0.051	0.049	0.064	0.080	0.112	0.004	0.000	-0.002
clicked	0.001	0.024	0.007	0.028	0.010	0.068	0.004	0.019	0.074	0.029	0.019	0.015	0.059	1.000	0.035	0.021	0.077	0.012	0.076	0.036	0.000	0.000	0.000	0.077	0.000	0.034	0.049	0.070	0.064	0.066	0.000	0.066	0.006	0.013	0.094	0.006	0.004	0.000	0.006	0.008
coupon_cabin_class	0.000	0.004	0.003	0.000	0.031	0.142	0.000	0.023	0.042	0.066	0.023	0.039	0.073	0.035	1.000	0.064	0.237	0.016	0.233	0.998	0.005	0.001	0.000	0.025	0.149	0.060	0.088	0.023	0.162	0.130	0.016	0.135	0.012	0.026	0.153	0.030	0.012	0.006	0.000	0.000
coupon_marketing_flight_number	-0.007	-0.013	-0.000	0.011	0.033	0.147	-0.010	0.026	0.014	0.020	-0.020	0.039	-0.022	0.021	0.064	1.000	-0.175	-0.043	0.149	0.035	-0.000	-0.003	0.006	0.020	0.026	-0.032	0.063	0.001	0.423	-0.084	0.025	-0.014	0.023	0.043	0.396	-0.030	0.026	0.008	-0.003	0.008
coupon_miles	0.076	0.049	-0.002	0.005	0.071	0.349	0.082	0.066	-0.106	0.060	-0.019	0.095	0.163	0.077	0.237	-0.175	1.000	0.055	0.586	0.141	-0.004	0.001	0.008	-0.064	0.135	-0.029	0.154	-0.035	0.557	0.470	0.058	-0.188	0.055	0.080	0.495	0.126	0.045	0.005	0.003	-0.005
coupon_number	0.029	0.023	-0.003	0.005	0.171	0.086	0.032	0.031	-0.047	0.026	0.498	0.220	0.026	0.012	0.016	-0.043	0.055	1.000	0.051	0.036	0.000	0.006	0.006	-0.001	0.049	0.107	0.066	-0.010	0.223	0.245	0.137	0.090	0.126	0.566	0.263	0.151	0.108	0.003	0.003	-0.007
coupon_range	0.003	0.008	0.000	0.000	0.068	0.322	0.005	0.065	0.108	0.066	0.062	0.089	0.114	0.076	0.233	0.149	0.586	0.051	1.000	0.153	0.000	0.000	0.004	0.060	0.074	0.142	0.231	0.058	0.446	0.330	0.057	0.326	0.053	0.075	0.398	0.090	0.000	0.003	0.002	0.002
coupon_rbd_code	0.356	0.010	0.001	0.033	0.130	0.055	0.338	0.125	0.059	0.300	0.067	0.174	0.103	0.036	0.998	0.035	0.141	0.036	0.153	1.000	0.000	0.009	0.000	0.056	0.202	0.041	0.050	0.072	0.068	0.075	0.105	0.084	0.097	0.078	0.074	0.050	0.135	0.000	0.000	0.000
flight_coupon_id	-0.001	-0.003	-0.005	0.004	0.005	0.009	-0.002	0.000	0.001	0.003	0.001	0.004	0.001	0.000	0.005	-0.000	-0.004	0.000	0.000	0.000	1.000	-0.005	0.000	-0.004	0.009	-0.004	-0.005	-0.001	0.000	0.004	0.013	-0.000	0.011	0.000	0.008	-0.000	0.005	0.004	-0.001	0.003
flight_leg_id	-0.005	0.005	0.004	0.000	0.005	0.005	-0.003	0.000	0.000	0.006	0.002	0.004	0.005	0.000	0.001	-0.003	0.001	0.006	0.000	0.009	-0.005	1.000	0.002	-0.001	0.000	-0.004	-0.001	-0.003	0.003	0.008	0.003	-0.004	0.000	0.000	0.010	-0.001	0.000	0.000	-0.005	-0.002
graphic_design	0.005	0.003	0.000	0.000	0.004	0.010	0.007	0.005	0.000	0.000	0.005	0.000	0.000	0.000	0.000	0.006	0.008	0.006	0.004	0.000	0.000	0.002	1.000	0.005	0.000	0.007	0.000	0.006	0.009	0.000	0.005	0.004	0.001	0.005	0.000	0.000	0.000	0.707	0.817	0.935
id	-0.035	0.028	-0.006	0.009	0.024	0.045	-0.030	0.021	0.153	0.020	0.047	0.069	-0.105	0.077	0.025	0.020	-0.064	-0.001	0.060	0.056	-0.004	-0.001	0.005	1.000	0.026	0.050	0.001	-0.001	0.074	-0.009	0.017	0.031	0.015	0.038	0.075	-0.001	0.037	0.001	-0.001	0.006
is_seat	0.052	0.008	0.000	0.015	0.050	0.162	0.050	0.053	0.022	0.087	0.095	0.042	0.035	0.000	0.149	0.026	0.135	0.049	0.074	0.202	0.009	0.000	0.000	0.026	1.000	0.053	0.079	0.025	0.148	0.065	0.020	0.074	0.023	0.012	0.157	0.034	0.022	0.000	0.000	0.002
leg_arrival_hour	-0.017	0.010	-0.003	0.009	0.034	0.127	-0.014	0.041	0.011	0.021	-0.014	0.048	-0.016	0.034	0.060	-0.032	-0.029	0.107	0.142	0.041	-0.004	-0.004	0.007	0.050	0.053	1.000	0.439	0.003	0.456	-0.133	0.028	0.054	0.024	0.113	0.341	-0.013	0.075	0.000	-0.002	-0.007
leg_departure_hour	-0.013	-0.010	0.002	0.011	0.048	0.182	-0.015	0.049	-0.023	0.039	-0.060	0.061	0.031	0.049	0.088	0.063	0.154	0.066	0.231	0.050	-0.005	-0.001	0.000	0.001	0.079	0.439	1.000	0.006	0.330	0.120	0.038	-0.302	0.037	0.135	0.427	0.045	0.071	0.003	0.001	-0.004
leg_departure_month	-0.008	0.004	0.005	0.005	0.021	0.054	-0.006	0.016	0.528	0.018	-0.003	0.064	0.018	0.070	0.023	0.001	-0.035	-0.010	0.058	0.072	-0.001	-0.003	0.006	-0.001	0.025	0.003	0.006	1.000	0.090	-0.014	0.018	-0.009	0.014	0.029	0.093	-0.010	0.036	0.005	0.001	0.004
leg_destination_country_code	0.021	0.031	0.003	0.031	0.071	0.179	0.022	0.114	0.074	0.100	0.078	0.098	0.076	0.064	0.162	0.423	0.557	0.223	0.446	0.068	0.000	0.003	0.009	0.074	0.148	0.456	0.330	0.090	1.000	0.406	0.032	0.158	0.051	0.391	0.142	0.049	0.559	0.018	0.013	0.013
leg_duration_h	0.044	0.022	0.004	0.012	0.074	0.168	0.045	0.058	-0.051	0.045	0.443	0.082	0.101	0.066	0.130	-0.084	0.470	0.245	0.330	0.075	0.004	0.008	0.000	-0.009	0.065	-0.133	0.120	-0.014	0.406	1.000	0.046	-0.210	0.043	0.072	0.351	0.076	0.145	0.000	-0.002	-0.003
leg_first_leg_flg	0.011	0.018	0.000	0.011	0.464	0.079	0.009	0.022	0.044	0.055	0.350	0.446	0.050	0.000	0.016	0.025	0.058	0.137	0.057	0.105	0.013	0.003	0.005	0.017	0.020	0.028	0.038	0.018	0.032	0.046	1.000	0.052	0.572	0.197	0.059	0.572	0.057	0.008	0.010	0.000
leg_hours_to_departure	0.004	-0.001	-0.001	0.006	0.073	0.265	0.004	0.060	0.040	0.043	0.090	0.081	-0.054	0.066	0.135	-0.014	-0.188	0.090	0.326	0.084	-0.000	-0.004	0.004	0.031	0.074	0.054	-0.302	-0.009	0.158	-0.210	0.052	1.000	0.052	0.101	0.733	-0.058	0.052	0.006	-0.001	-0.004
leg_last_leg_flg	0.011	0.013	0.006	0.000	0.459	0.077	0.011	0.020	0.043	0.051	0.344	0.441	0.051	0.006	0.012	0.023	0.055	0.126	0.053	0.097	0.011	0.000	0.001	0.015	0.023	0.024	0.037	0.014	0.051	0.043	0.572	0.052	1.000	0.189	0.077	1.000	0.058	0.000	0.000	0.000
leg_number	0.006	0.021	0.002	0.020	0.482	0.075	0.008	0.034	0.091	0.043	0.245	0.293	0.049	0.013	0.026	0.043	0.080	0.566	0.075	0.078	0.000	0.000	0.005	0.038	0.012	0.113	0.135	0.029	0.391	0.072	0.197	0.101	0.189	1.000	0.418	0.136	0.049	0.000	0.006	0.005
leg_origin_country_code	0.000	0.028	0.003	0.009	0.134	0.231	0.012	0.116	0.081	0.087	0.114	0.153	0.064	0.094	0.153	0.396	0.495	0.263	0.398	0.074	0.008	0.010	0.000	0.075	0.157	0.341	0.427	0.093	0.142	0.351	0.059	0.733	0.077	0.418	1.000	0.051	0.581	0.000	0.000	0.000
leg_stopover_time_h	0.033	0.021	-0.002	0.000	0.265	0.068	0.035	0.015	-0.051	0.030	0.298	0.312	0.080	0.006	0.030	-0.030	0.126	0.151	0.090	0.050	-0.000	-0.001	0.000	-0.001	0.034	-0.013	0.045	-0.010	0.049	0.076	0.572	-0.058	1.000	0.136	0.051	1.000	0.064	0.000	0.000	-0.004
preffered_language	0.023	0.027	0.002	0.003	0.129	0.592	0.022	0.087	0.082	0.348	0.171	0.144	0.112	0.004	0.012	0.026	0.045	0.108	0.000	0.135	0.005	0.000	0.000	0.037	0.022	0.075	0.071	0.036	0.559	0.145	0.057	0.052	0.058	0.049	0.581	0.064	1.000	0.000	0.000	0.000
top_1_section	0.000	0.004	0.004	0.000	0.006	0.000	0.000	0.000	0.000	0.000	0.003	0.003	0.004	0.000	0.006	0.008	0.005	0.003	0.003	0.000	0.004	0.000	0.707	0.001	0.000	0.000	0.003	0.005	0.018	0.000	0.008	0.006	0.000	0.000	0.000	0.000	0.000	1.000	0.568	0.632
top_2_section	0.003	0.003	-0.000	0.001	0.004	0.005	0.005	0.003	-0.003	0.001	0.002	0.003	0.000	0.006	0.000	-0.003	0.003	0.003	0.002	0.000	-0.001	-0.005	0.817	-0.001	0.000	-0.002	0.001	0.001	0.013	-0.002	0.010	-0.001	0.000	0.006	0.000	0.000	0.000	0.568	1.000	0.098
top_3_section	0.003	0.007	-0.002	0.004	0.005	0.010	0.004	0.000	0.001	0.000	-0.003	0.000	-0.002	0.008	0.000	0.008	-0.005	-0.007	0.002	0.000	0.003	-0.002	0.935	0.006	0.002	-0.007	-0.004	0.004	0.013	-0.003	0.000	-0.004	0.000	0.005	0.000	-0.004	0.000	0.632	0.098	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	id	booking_adult_count	booking_child_count	booking_destination_airport_code	booking_id	booking_leg_count	booking_market	booking_origin_airport_code	booking_original_currency	booking_pax_count	booking_payment_method	booking_reservation_month	booking_sales_channel	booking_segments_count	booking_trip_type	booking_window_w	coupon_cabin_class	coupon_destination_airport_code	coupon_fare_basis	coupon_marketing_flight_number	coupon_miles	coupon_number	coupon_origin_airport_code	coupon_range	coupon_rbd_code	email	flight_coupon_id	flight_leg_id	is_seat	leg_arrival_hour	leg_arrival_timezone_code	leg_departure_hour	leg_departure_month	leg_departure_timezone_code	leg_destination_airport_code	leg_destination_country_code	leg_duration_h	leg_first_leg_flg	leg_hours_to_departure	leg_last_leg_flg	leg_number	leg_origin_airport_code	leg_origin_country_code	leg_stopover_time_h	pnr	preffered_language	request_dttm	request_id	clicked	graphic_design	top_1_section	top_2_section	top_3_section
0	105529	1	0	TBS	6386840	2	GE	WAW	GEL	1	95582540167d4ebb9497a7031f046757	1	website	2	RT	4	economy	WAW	ee702af56c9f42c49677ede02047afcd	8102495	1334	2	TBS	SH	b6460aef6f204ba8940329aa9f7f99cd	4a0d5a2fe1974c1f8e8082afa8bdd72b	7604138	1585907	0	6	Europe/Warsaw	5	2	Asia/Tbilisi	WAW	NaN	0	1	74	0	2	TBS	NaN	365	40faefe514be47b38cea3be065583d7f	en_gb	2014-03-02T21:13:05.030Z	ee37548ce2a74b99b41d67f4d2a138fd	0	C	6	3	0
1	28386	1	0	WAW	6842736	2	US	EWR	USD	1	95582540167d4ebb9497a7031f046757	8	website	2	RT	2	economy	EWR	64e30cc1470248f6896a74d5774954b8	3391275	4268	2	WAW	LH	5b4d18c017084084b2c8e3860625237e	eb3f322048494f7ea59d63bb636772c8	1440297	8701111	1	20	America/New_York	17	9	Europe/Warsaw	EWR	US	3	1	71	0	2	WAW	NaN	325	7fafefddde544aba95c69552cfbadd51	en_gb	2013-10-09T11:08:14.112Z	f083457969dd46d2ada761198096ecc4	1	B	4	3	5
2	107663	1	0	BEG	3164316	2	PL	SZZ	NaN	1	1bb2b25a099d4a438425d276203a0c2c	2	website	4	RT	0	economy	WAW	76c8fafae85c47e0849a2b85b23dce08	1303546	507	3	BEG	SH	fcd7f2fe3e034355bcc3fff350b5c928	93fe4d004f074298ae540784f5466926	8864878	2564724	0	20	Europe/Warsaw	13	2	Europe/Belgrade	SZZ	NaN	6	0	71	1	2	BEG	NaN	-9999	6240c081718e4439a3174ac38a2c9c45	en_gb	2014-03-08T08:15:38.344Z	9df9a894f4374dfba0d8811dd99c1b1e	0	C	3	6	0
3	24881	1	0	BOM	3835074	1	SE	WAW	NaN	1	1bb2b25a099d4a438425d276203a0c2c	9	agents	1	OW	0	economy	BOM	9915e38b5cf247588f6f4ae680b53f5e	2394395	3591	1	WAW	LH	06461e5ef0bb4941995dadba33f4b58a	a9a8894fee5d44da923224e46a280e9c	4806814	6460284	0	2	Asia/Kolkata	15	9	Europe/Warsaw	BOM	NaN	11	1	71	1	1	WAW	NaN	-9999	231c99e3d0644366827e91276296e3cc	en_gb	2013-10-06T09:09:48.597Z	89c95fa040db42d4a1982c7901128585	1	A	3	1	2
4	90383	1	0	OTP	5962948	2	PL	OSL	PLN	1	95582540167d4ebb9497a7031f046757	10	agents	4	RT	9	economy	WAW	0b93a67a450640c19f68cd8e77464ffa	8788690	671	1	OSL	SH	fcd7f2fe3e034355bcc3fff350b5c928	7e7a981bfcff46aa9077f2dd2803ac57	2708982	9204582	0	1	Europe/Bucharest	19	12	Europe/Oslo	OTP	NaN	5	1	71	0	1	OSL	NaN	249	4854301527cf48f7a32c9625a154874b	en_gb	2014-01-07T14:14:06.568Z	d44b65a240374e61867039b37c98f9a0	1	B	3	4	5
5	37616	1	0	JFK	4772021	2	PL	WAW	PLN	1	95582540167d4ebb9497a7031f046757	8	agents	2	RT	5	premium	WAW	7be28cf8c9c748ba81b3be6abf5132dd	7648128	4255	2	JFK	LH	b594ecdd148e4893a8be54afc5783eb7	560894c6149647e0b43ad23fb95ced87	2805853	5023742	1	13	Europe/Warsaw	22	10	America/New_York	WAW	NaN	14	0	65	1	2	JFK	NaN	-9999	d6d7da1536074ab9a2df8a3575c90e0a	en_gb	2013-10-18T22:04:46.740Z	f6d1903c1ff24372932b8410c35afc09	0	B	4	3	5
6	30135	2	0	BCN	7868365	2	PL	WAW	PLN	2	95582540167d4ebb9497a7031f046757	7	website	2	RT	9	economy	WAW	827044bc992241a7a6e0a821d48d6967	7174818	1162	2	BCN	SH	5b4d18c017084084b2c8e3860625237e	12e3c755b9d9443dbd2ba1b182716f69	8578738	9799232	0	16	Europe/Warsaw	13	9	Europe/Madrid	WAW	PL	3	0	71	1	2	BCN	ES	-9999	e7352d3377f84d2ab8c3c103e849109e	pl_pl	2013-10-11T07:07:08.502Z	a9e4f2e6e9454e22ad5f8211a31179a7	1	A	3	2	1
7	45344	1	0	LCY	4155457	2	PL	VNO	PLN	1	95582540167d4ebb9497a7031f046757	9	website	2	RT	3	economy	VNO	2e3e48530fc94e3d8f178a76955d9e5c	8072518	1063	2	LCY	SH	06461e5ef0bb4941995dadba33f4b58a	af25bbb58076464db7c8c4bdaccdf8fb	3599594	5980874	0	23	Europe/Vilnius	18	10	Europe/London	VNO	NaN	4	1	70	0	2	LCY	NaN	123	59ebc18b9d8f41ed8ed00db422b2159c	en_gb	2013-10-26T13:11:21.909Z	e825ceb099a64eeba27ff931a38c4aba	0	A	1	2	3
8	75045	1	0	NaN	8205418	2	JP	NRT	JPY	1	95582540167d4ebb9497a7031f046757	9	website	4	MC	10	economy	PRG	0cf08327bd024d58928a4437d3a0a4c0	4837468	323	2	WAW	SH	06461e5ef0bb4941995dadba33f4b58a	ea4df15d902e4438929a53c0bfa634aa	9021794	1154898	0	17	Europe/Prague	23	11	Asia/Tokyo	PRG	NaN	18	0	78	1	1	NRT	NaN	-9999	742662528ac141ada5e98c1a012b3c51	en_gb	2013-11-30T10:05:50.378Z	d8abd0a4e5c641b0951752e73b9e5ff6	0	B	3	5	4
9	22833	1	1	WRO	5740133	2	KR	ICN	KRW	2	95582540167d4ebb9497a7031f046757	9	aiport_agents	2	RT	2	economy	WRO	3e1b3ece53714b3096655cab2ac98bb7	6877925	4985	1	ICN	LH	b6460aef6f204ba8940329aa9f7f99cd	be430c9c63154d81aa0ece356930e65e	3829812	2549236	0	14	Europe/Warsaw	8	9	Asia/Seoul	WRO	NaN	6	1	78	0	1	ICN	NaN	1189	7c53d18a8ec743b392831e7d60db7a2f	en_gb	2013-10-04T19:05:03.599Z	decb15efda654e89a9ae3b80bd51ff31	1	B	4	3	5

	id	booking_adult_count	booking_destination_airport_code	booking_id	booking_leg_count	booking_market	booking_origin_airport_code	booking_original_currency	booking_pax_count	booking_payment_method	booking_reservation_month	booking_sales_channel	booking_segments_count	booking_trip_type	booking_window_w	coupon_cabin_class	coupon_destination_airport_code	coupon_fare_basis	coupon_marketing_flight_number	coupon_miles	coupon_number	coupon_origin_airport_code	coupon_range	coupon_rbd_code	email	flight_coupon_id	flight_leg_id	is_seat	leg_arrival_hour	leg_arrival_timezone_code	leg_departure_hour	leg_departure_month	leg_departure_timezone_code	leg_destination_airport_code	leg_destination_country_code	leg_duration_h	leg_first_leg_flg	leg_hours_to_departure	leg_last_leg_flg	leg_number	leg_origin_airport_code	leg_origin_country_code	leg_stopover_time_h	pnr	preffered_language	request_dttm	request_id	clicked	graphic_design	top_1_section	top_2_section	top_3_section
84939	73819	1	WAW	6538636	2	KR	ICN	KRW	1	95582540167d4ebb9497a7031f046757	9	agents	2	RT	4	economy	ICN	9e49b681c5d2403d86e30d3d794bf793	4387324	4801	2	WAW	LH	5b4d18c017084084b2c8e3860625237e	e0afecb4e7954a2e87837602f6112fda	7279220	5875102	0	7	Asia/Seoul	11	11	Europe/Warsaw	ICN	NaN	19	1	71	0	2	WAW	NaN	513	076f220f7b1a437e99a07a09a9884b70	en_gb	2013-11-29T06:06:50.242Z	07ef4258276146cdb2ed7847cce9d238	0	C	3	6	0
84940	53876	4	CDG	2130240	2	PL	WAW	PLN	4	95582540167d4ebb9497a7031f046757	9	internal_agents	2	RT	5	economy	CDG	4dd0a4d3f47c4a9b966440cc2277b291	1156936	835	1	WAW	SH	fcd7f2fe3e034355bcc3fff350b5c928	714c942b14dc451982a38ee32ee58992	2819062	1545899	0	9	Europe/Paris	7	10	Europe/Warsaw	CDG	NaN	2	1	71	0	1	WAW	NaN	52	8120eafc2a5142a285bcd3ea5466abf1	en_gb	2013-11-04T01:05:52.215Z	8d50c38759df4077a7b942a83d85b88b	0	C	3	6	0
84941	107921	1	OSL	7182852	1	NO	OTP	NOK	1	95582540167d4ebb9497a7031f046757	2	agents	2	OW	2	economy	WAW	9c1cc0d336174cb08dbcde11e420d2fa	2567994	574	1	OTP	SH	b6460aef6f204ba8940329aa9f7f99cd	541890ff14dc43dea881d005f95a775e	9118786	4226114	1	9	Europe/Oslo	5	2	Europe/Bucharest	OSL	NaN	4	1	72	1	1	OTP	NaN	-9999	bc4db3c451194b5aba3653b599c942e9	en_gb	2014-03-08T23:11:46.444Z	255cd4653ff94b738dbae508f248e0d7	1	C	3	6	0
84942	45350	1	DUS	1303330	2	PL	WAW	PLN	1	95582540167d4ebb9497a7031f046757	5	website	2	RT	20	economy	DUS	d576b543eb25443ba0540b652e0d31cb	3519803	609	1	WAW	SH	5b4d18c017084084b2c8e3860625237e	390bec66d9674f59b6a353ecd4eb2d87	7961879	4142908	0	22	Europe/Berlin	20	10	Europe/Warsaw	DUS	DE	1	1	70	0	1	WAW	PL	71	e0542e2aa26443829200371053d8e000	pl_pl	2013-10-26T14:09:09.501Z	ae12b27dad79483a8bb9b833ffd08499	0	C	6	3	0
84943	101649	1	VNO	3895709	2	GB	LCY	GBP	1	95582540167d4ebb9497a7031f046757	1	website	2	RT	0	economy	LCY	3b59b3a71f574df286ca061a8b0b2022	7808418	1063	2	VNO	SH	fcd7f2fe3e034355bcc3fff350b5c928	4f0877bc07214f6682c7ca1ebb7d5c43	6136100	4142373	0	18	Europe/London	17	2	Europe/Vilnius	LCY	NaN	1	1	72	0	2	VNO	NaN	93	183eebaf76cc4817a64e7e71e5cfafe9	en_gb	2014-02-19T10:12:15.277Z	c5811bca94314c5292f1128a28c61610	0	C	6	3	0
84944	7634	1	WAW	5494177	2	US	EWR	USD	1	95582540167d4ebb9497a7031f046757	7	website	2	RT	2	economy	EWR	29495f5a2b9245c6aa4fb92421cca708	4101912	4268	2	WAW	LH	22da46f1ddc1406e8e6aa78cdf573c16	3f8745c0a93e43bf923424000f6a1816	5087155	4135034	0	18	America/New_York	14	9	Europe/Warsaw	EWR	US	3	1	71	0	2	WAW	PL	710	d86c510a2b114288bc6ca23cbdb20731	pl_pl	2013-09-21T08:09:47.626Z	c96bd1b541614661a3ec092f4594e5c1	1	B	4	3	5
84945	67152	1	ICN	4024574	2	PL	WRO	PLN	1	95582540167d4ebb9497a7031f046757	2	website	2	RT	36	economy	ICN	8a56b615f68b49dfac02202927f5dc52	7179801	4985	1	WRO	LH	b6460aef6f204ba8940329aa9f7f99cd	07d4a93a28ab4f85aa691f92b9c8f1c3	9436653	3291412	0	11	Asia/Seoul	16	11	Europe/Warsaw	ICN	NaN	19	1	71	0	1	WRO	NaN	1163	882f81dc62264d18be14b0c346249888	en_gb	2013-11-16T11:11:36.066Z	22e4542ce44049da8a6f20ed6238faf0	1	B	3	4	5
84946	94614	2	DEL	9014936	2	PL	WAW	PLN	2	95582540167d4ebb9497a7031f046757	9	website	2	RT	15	economy	WAW	8d18c23df78e49318aae6e61dcfbbee3	5094257	3270	2	DEL	LH	5b4d18c017084084b2c8e3860625237e	fc67a620f82e45ecae47fef52fb0867a	3181255	5838116	0	12	Europe/Warsaw	7	1	Asia/Kolkata	WAW	PL	4	1	75	0	2	DEL	IN	443	828a20846c724728ac8a0760efdf6df6	pl_pl	2014-01-27T22:12:08.965Z	2532b32403f2417fb5717281ddadb9df	1	C	3	6	0
84947	1031	2	DBV	5195800	2	PL	WAW	PLN	2	95582540167d4ebb9497a7031f046757	8	website	2	RT	3	economy	WAW	74e7a680e5b5456c803bc695ae1c5e8b	4679285	674	2	DBV	SH	fcd7f2fe3e034355bcc3fff350b5c928	976f2ce7602644fd8c39e2dc1250b9e0	7818370	7533678	1	21	Europe/Warsaw	19	8	Europe/Zagreb	WAW	PL	1	0	71	1	2	DBV	HR	-9999	0e0f7bb498134733a28aae066201993d	pl_pl	2013-09-15T12:34:09.192Z	e5d4b884d3f24c54a47162af74a1ad09	0	A	3	2	1
84948	19208	2	FCO	8300743	2	PL	WAW	PLN	2	95582540167d4ebb9497a7031f046757	9	website	2	RT	1	economy	FCO	bf4837e7d7b041f2a583783bbe866436	6672512	823	1	WAW	SH	05aa66ad90564e9caf593f69bf0df44c	a03320192e4e4a66bf8ea324c8d6b7f5	6999715	1495000	0	18	Europe/Rome	15	9	Europe/Warsaw	FCO	IT	2	0	71	1	1	WAW	PL	-9999	815e167f6e56449e90d6fc13826cb361	pl_pl	2013-10-01T09:07:56.159Z	195a4dc345f4494aa474aca7f271d556	0	B	4	3	5

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)